Count a Measure

[RNightscape]

Hi all.

Please, anyone could help?

On my matrix I have some results (green, red) created by a measure.

I would like to count the number of "green" for each depart.

Thanks

[Greg_Deckler · Accepted solution]

Sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, you could do something like:

Measure = COUNTROWS(FILTER(SUMMARIZE('Table',[Product],[Category],"__Measure",[Measure]),[__Measure]="GREEN"))

[RNightscape]

Thank you very much by your help!