[DUPLICATE] Limit On-Demand Load When Value is Not Equal To X

[Aleister Mraz 2]

This question was previously asked here, but the solution offered does not work for me.

I've a data table imported, marked the On-Demand settings to "Data on demand", selected the [Define Input...] button for the {TECHNOLOGY} column, chose "Values (fixed/properties/expression)", and for the Expression, I've tried the following (and more):

 

If([TABLE].[TECHNOLOGY]!="TEST",[TABLE].[TECHNOLOGY],NULL)

 

If([TABLE].[TECHNOLOGY]="TEST",[TABLE].[TECHNOLOGY],NULL)

 

If([TABLE].[TECHNOLOGY]!="TEST",true,false)

 

If([TABLE].[TECHNOLOGY]="TEST",true,false)

 

true

 

false

 

[TABLE].[TECHNOLOGY]

 

[TECHNOLOGY]

 

[TABLE].[TECHNOLOGY]!="TEST"

 

[TABLE].[TECHNOLOGY]="TEST"

My table has three columns:

 

 

 

Department

Group

TECHNOLOGY

 

 

 

 

Area1

TeamA

TEST

 

 

Area1

TeamB

TEST

 

 

Area2

TeamA

NextGen

 

 

Area2

TeamA

TEST

 

 

 

 

 

 

 

 

 

As aforementioned, every expression I try returns only the column headers and no rows for this table when using data-on-demand w/ expressions. Simply, I would like to see every row that is not TEST.