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 countr...
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    NinoLag Sorry, I missed a paren. 

    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
3 years ago

NinoLag Maybe:

Measure = IF(SELECTEDVALUE('Table'[Column1])="NO",1,IF(NOT (MAX('IHtoberefreshed (2)'[Country]) IN {"Australia", "Germany"},1))
NinoLag's avatar
NinoLag
New Member
3 years ago

Hi Greg_Deckler !

 

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

 

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    NinoLag Sorry, I missed a paren. 

    Measure = IF(SELECTEDVALUE('Table'[Column1])="NO",1,IF(NOT (MAX('IHtoberefreshed (2)'[Country]) IN {"Australia", "Germany"}),1))
    • NinoLag's avatar
      NinoLag
      New Member
      3 years ago

      Hi again Greg_Deckler ,

       

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

       

      BR

      Nino