topic Exclude multiple values from Column Filter in DAX Commands and Tips

Exclude multiple values from Column Filter

Anonymous — Mon, 11 May 2020 14:09:35 GMT

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 — Mon, 11 May 2020 10:46:25 GMT

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

EllenG — Mon, 15 Jun 2020 16:45:09 GMT

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

romgut — Fri, 11 Sep 2020 07:05:45 GMT

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"} )