Forum Discussion

zahidah_mabd's avatar
zahidah_mabd
Helper I
4 years ago
Solved

Filter Not Equal To Text Not Working

Hi,  I want to create a measure that filters out certain values from a few columns.   [Employee Category] is equal to "Contract - TTS" and "Permanent -TTS" [Job Grade] is not equal to "TTS1" and "...
Need Help
  • rajulshah's avatar
    rajulshah
    4 years ago

    Hello zahidah_mabd ,

     

    Please try the following measure:

    Sum Mismatch TTS Job Grade = 
CALCULATE( COUNTROWS('table),
FILTER(
'table',
('table'[Employee Category] = "Permanent - TTS" ||
'table'[Employee Category] = "Contract - TTS") &&
('table'[Job Grade] <> "TTS1" &&
'table'[Job Grade] <> "TTS2" )
)
)+0

     

    This is based on the measure you provided, but if we go by the conditions you provided above your formula, the DAX query provided is incorrect.
    Please validate.

rajulshah's avatar
rajulshah
Resident Rockstar
4 years ago

Hello zahidah_mabd ,

 

Please try the following measure:

Sum Mismatch TTS Job Grade = 
CALCULATE( COUNTROWS('table),
FILTER(
'table',
('table'[Employee Category] = "Permanent - TTS" ||
'table'[Employee Category] = "Contract - TTS") &&
('table'[Job Grade] <> "TTS1" &&
'table'[Job Grade] <> "TTS2" )
)
)+0

 

This is based on the measure you provided, but if we go by the conditions you provided above your formula, the DAX query provided is incorrect.
Please validate.

  • zahidah_mabd's avatar
    zahidah_mabd
    Helper I
    4 years ago

    Yay, it worked like a charm! Thank youuuu so much rajulshah 

    Also, can you explain a bit about when u mentioned the DAX Query is incorrect. Im still new to power BI

    • rajulshah's avatar
      rajulshah
      Resident Rockstar
      4 years ago

      My pleasure zahidah_mabd .

       

      When I saw the latest description, it was edited and it now makes sense for the formula you used. For the earlier description, I thought it was not correct.

      Anyway, glad that it worked out.