How to get the count of two different Categories in same column

[gyan09]

Hi All, I have one column which includes "Compliant" and "Non Compliant" category. I want to Put the card in Power BI desktop which shows the number of Compliant and Non Compliant separately. Could you please help me with this. Thanks in advance ! Regards Gyan

[Jbrown214]

What if there are numerous categories and I do not want to hard code each value within the filter statement. What is another query statement I could use?

[v-frfei-msft · Accepted solution]

Hi @gyan09 ,

To create two measure as below.

Compliant = CALCULATE(COUNT(Table1[Column1]),FILTER(Table1,Table1[Column1]="Compliant"))

Non Compliant = CALCULATE(COUNT(Table1[Column1]),FILTER(Table1,Table1[Column1]="Non Compliant"))

Pbix as attached.