Exclude multiple values from Column Filter

[Anonymous]

I'm currently trying to filter a column "Value" to ensure the following values dont appear:

Sheep Enterprise Flock 1

Sheep Enterprise Flock 2

Lambs From Previous Year to Sell

But keep getting : A table of multiple values was supplied where a single value was expected.

Can anyone help?

[AlB · Accepted solution]

Hi @Anonymous 

Try NOT IN instead of the inequality for your condition:

NOT Looker_tables lkr_Form_Checkbox_Answer'[Value] IN {"Sheep Enterprise Flock 1","Sheep Enterprise Flock 2","Lambs From Previous Year to Sell"}

Please mark the question solved when done and consider giving kudos if posts are helpful.

 Cheers 

[romgut]

It's also working as part of the calculate syntax , e.g.

Measure =

CALCULATE ( COUNTROWS(table) , table[field]="Lost" , not table[field] in {"PTG 1A", "PTG 1B"} )

[EllenG]

Worked for me too! Thank you @AlB Super User III !!