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.