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
I have a visual with a matrix and am trying to get the subtotals as an average rather than a sum. How would I go about doing this?
Is this feasible?
Thanks
Sarath
Solved! Go to Solution.
Hi, you can use "average per category" quick measure, to learn about "quick measures" check here.
In the example, with the quick measure i get "average of sales monthly" instead of the "sum of sales":
The code of the "quick measure" is:
Hi, you can use "average per category" quick measure, to learn about "quick measures" check here.
In the example, with the quick measure i get "average of sales monthly" instead of the "sum of sales":
The code of the "quick measure" is:
Thank you Maguilar. This helped me achieve Average value in column subtotals.
Thanks Maguilar
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |