Forum Discussion

NinoLag's avatar
NinoLag
New Member
3 years ago
Solved

Multiple Not Equal To Power BI Measure

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.
  • NinoLag Sorry, I missed a paren. 

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

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    NinoLag Maybe:

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

        NinoLag Sorry, I missed a paren. 

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