cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sce7dmas Frequent Visitor
Frequent Visitor

Sum of average - Additional assistance

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Sum of average - Additional assistance

@sce7dmas ,

 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Sum of average - Additional assistance

@sce7dmas ,

 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sce7dmas Frequent Visitor
Frequent Visitor

Re: Sum of average - Additional assistance

Thank you for your reply. It took some thinking but I now understand this function better.