topic Re: Multiple Not Equal To Power BI Measure in DAX Commands and Tips

Multiple Not Equal To Power BI Measure

NinoLag — Thu, 08 Sep 2022 11:57:57 GMT

Hello,

I would like to make a YES/NO slicer where NO shows all countries and YES shows the official scope with some countries excluded.

I found the formula below and it is working for one country.

If I would like to exclude mutiple countries, how do I include them in the same formula?

Or should I use another approach?

Measure = IF(SELECTEDVALUE('Table'[Column1])="NO",1,IF(MAX('IHtoberefreshed (2)'[Country])<>"Australia",1))

Thanks.

Greg_Deckler — Thu, 08 Sep 2022 12:12:54 GMT

Measure = IF(SELECTEDVALUE('Table'[Column1])="NO",1,IF(NOT (MAX('IHtoberefreshed (2)'[Country]) IN {"Australia", "Germany"},1))

NinoLag — Thu, 08 Sep 2022 12:20:28 GMT

I entered it and it seems as if it doesn't like something:

Greg_Deckler — Thu, 08 Sep 2022 18:54:42 GMT

NinoLag Sorry, I missed a paren.

Measure = IF(SELECTEDVALUE('Table'[Column1])="NO",1,IF(NOT (MAX('IHtoberefreshed (2)'[Country]) IN {"Australia", "Germany"}),1))

NinoLag — Fri, 09 Sep 2022 06:25:20 GMT

That worked! Thank you a lot for your help and fast replies!

Nino