Filter Not Equal To Text Not Working

[zahidah_mabd]

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 "TTS2" (meaning that only TTS1 and TTS2 are valid grades, The rest is considered Incorrect)

So I want to create a measure to count the total data that has the incorrect salary grade for the employee category.

This is my 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

But unfortunately, it doesnt filter the not equal to part correctly. Both columns are text type.

Employee Category	Job Grade	Match
Permanent - TTS	TTS1	Correct
Contract - TTS	TTS2	Correct
Contract - TTS		Incorrect
Permanent - TTS	FG3	Incorrect
Permanent - ABC	QR2	Correct
Contract - CDR	TTS2	Incorrect

This is an example of data, the bold column does not exist but only to illustrate the matching for category and job grade. What I want is to count the number of Incorrect value specifically for TTS (contract and Permanent) 

Can anyone help me?

[rajulshah · Accepted solution]

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]

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]

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.

[tamerj1]

Hi @zahidah_mabd 
Please try

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