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.
It is possible to change the subtotals of a Matrix from sum to average.
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/monthly-average-of-daily-sums/m-p/291451#M128396
Hello,
The way grand total works is based on the column if you take Sum in the column it will give a grand total of the sum if you want average change you calculation to average and grand total will be based on average.
Let me know if this not you are expecting or give us sample data.
Thanks for your answer, the issue is that the columns I need with the sum , but at the end in the subtotal I Need an average based on the sum columns.
Hi,
So i have created 2 calculations
Avg and Sum
I am checking if total count of columns= total rows in a table then give me "average" else give me "
"sum".
Sum = CALCULATE(SUM('Table 1'[SPHA's Filled]),ALLEXCEPT('Table 1','Table 1'[Job: Name])) ( which will give you sum)
Avg =CALCULATE(AVERAGE('Table 1'[SPHA's Filled]),ALLEXCEPT('Table 1','Table 1'[Job: Name])) (which will give you average)
Grand total Formula :
Total = if(COUNT(a[write your column])=COUNTROWS('Table 1'),[avg],[sum])
Thanks,
Aditya
If you have got it, Please mark this as closed.
Thanks
Aditya
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |