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.

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.