Count values that match criteria

[Anonymous]

Hello,

I am trying to count how many "Wrong Worksets" I have on a table.

The result should be 3.

But this formula is counting 9

CT Worksets Non-Standard = COUNTAX('Worksets2-4','Worksets2-4'[WorksetName]="Wrong Workset")

And this one is just showing (Blank)

CT Worksets Non-Standard 2 = CALCULATE(COUNTROWS('Worksets2-4'),'Worksets2-4'[WorksetName]="Wrong Workset")

This is the table

WorksetName	CT Workset Check
Workset1	Wrong Workset
Shared Levels and Grids	OK
MEP (CT)	Wrong Workset
Structural (CT)	Wrong Workset
Links CAD	OK
Links CAD - Survey	OK
Links RVT - Arch	OK
Links RVT - MEP	OK
Links RVT - Struc	OK

Thank you

J

[parry2k · Accepted solution]

@Anonymous following measure should work but reason you are getting blank because there is no "Wrong Workset" value in worksetname column, I guess you want to use "CT Workset Check" column in  your measure

CT Worksets Non-Standard 2 = CALCULATE(COUNTROWS('Worksets2-4'),'Worksets2-4'[CT Workset Check]="Wrong Workset")

[Anonymous]

I am so ashamed of myself.....

Thank you @parry2k 

Spot on!