Count number of rows in measure output that meet criteria.

[StuartSmith]

I have a measure (Attrition Country KPI) that compares 2 other measures (Attrition & Max Half Yearly Level) and depending on the result, will display various outputs including "KPI Breached".  I need to create a measure that will count the number of "KPI Breached" per region.

Can this be done and if so, how?  Thanks in advance.

[StuartSmith]

Thanks, I was almost there, was just missing the "Values" bit. Will have a read up on that function.

[Ashish_Mathur · Accepted solution]

Hi,

This measure will count

=countrows(filter(values(Data[Country]),[Attrition Country KPI]="KPI Breached"))

Hope this helps.