cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RNightscape Frequent Visitor
Frequent Visitor

Count a Measure

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.

 

 

POWERBI.jpg

 

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Count a Measure

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"))

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


2 REPLIES 2
Super User
Super User

Re: Count a Measure

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"))

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


RNightscape Frequent Visitor
Frequent Visitor

Re: Count a Measure

Thank you very much by your help!