Forum Discussion
Count values that match criteria
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
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")
2 Replies
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")