Forum Discussion

zahidah_mabd's avatar
zahidah_mabd
Icon for Helper I rankHelper 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
Icon for Resident Rockstar rankResident 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
Icon for Helper I rankHelper 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
    Icon for Resident Rockstar rankResident 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.