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 been reading a couple of posts on getting the Sum of Averages into a pivot table.
https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013
https://community.powerbi.com/t5/Desktop/Sum-of-Averages-in-calc-column/m-p/457290#M211950
I have read through the above and tried to understand what they are doing but cannot get my head around it.
Any assistance would be very much appreciated.
I have a snapshot of the table here, with the two columbs on the right being examples of what I am trying to calculate as the sum of the averages against each supplier:
Row Labels | Average of AVG Cost | Average of Unit Cost Bid 2018 SS | Average of USD PO Unit Cost SS | Sum of Average of Unit Cost Bid 2018 SS | Sum of Average of USD PO Unit Cost SS | |
Supplier X | $ 8.38 | $ 8.43 | $ 8.36 | $ 61.48 | $ 69.71 | |
xxx1 | $ 0.23 | $ 0.23 | $ 0.23 | |||
xxx2 | $ 4.51 | $ 4.60 | $ 4.47 | |||
xxx3 | $ 17.17 | $ 17.15 | $ 17.15 | |||
xxx4 | $ 39.51 | $ 39.50 | $ 39.50 | |||
Supplier Y | $ 28.30 | $ 17.80 | $ 28.35 | $ 239.73 | $ 307.52 | |
yyyy1 | $ 29.94 | $ 28.50 | $ 30.14 | |||
yyyy2 | $ 25.57 | $ 24.86 | $ 26.39 | |||
yyyy3 | $ 5.43 | $ 5.53 | $ 5.87 | |||
yyyy4 | $ 4.45 | $ 4.52 | $ 4.80 | |||
yyyy5 | $ 30.11 | $ 27.92 | $ 29.64 | |||
yyyy6 | $ 9.76 | $ 9.05 | $ 9.60 | |||
yyyy7 | $ 38.98 | $ 33.38 | $ 38.42 | |||
yyyy8 | $ 50.84 | $ 45.90 | $ 52.83 | |||
yyyy9 | $ 14.37 | $ 13.36 | $ 14.19 | |||
yyyy10 | $ 24.02 | $ 23.79 | $ 25.25 | |||
yyyy11 | $ 59.76 | $ 12.97 | $ 59.84 | |||
yyyy12 | $ 10.31 | $ 9.95 | $ 10.56 | |||
$ 301.22 | $ 377.23 |
Thanks for any assistance you can offer
Solved! Go to Solution.
@Anonymous ,
You may refer to the following post.
@Anonymous ,
You may refer to the following post.
Thank you for your reply. It took some thinking but I now understand this function better.
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 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |