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!
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!