Sum/count of true events in a measure

[Anonymous]

Hi Guys

I have created a standard matrix as below. Now i would like create a table or matrix next to it showing the number of Pick IDs where the average percentage in the selected period is above 40%, below 10% and in between.  I am using a date slicer.

I've tried creating a measure that returns a 1 if the average for example is above 40% but i can't find a function to counts the 1s that are returned. 

Measure formula is = IF(AVERAGE('Salling Group'[Utilization %])>0,4 , 1 , 0)

Hope my question makes sense. 🙂

[ntaylo06]

You won't want to use a measure for this, a measure is a single calculation. If you create a new matrix/table and fill it with the exact same data, you should be able to filter it based on the value of a field, like this: 

[Anonymous]

Thanks for the reply.

That would create a table that shows alle items with an average of above 40% and the grand total would be the average of all the items.

I just need a count of all the items that has an average ov over 40%.

[ntaylo06]

In that case, use something like:

Forty Plus Average = CALCULATE(AVERAGE('table'[field]), 'table'[average] > .4)

But when you say "the grand total would be the average of all the items" that is describing the total of a table. You also said you wanted a table in your original post. Can you please clarify which one you are wanting?