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.
Go to 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"))
Proud to be a Datanaut!
Thank you very much by your help!
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.