Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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. 🙂
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:
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%.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |