Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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'[...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    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")
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    I am so ashamed of myself.....

     

    Thank you parry2k 

    Spot on!