cancel
Showing results for
Did you mean:
Highlighted
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

## Re: Sum of average - Additional assistance

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

## Re: Sum of average - Additional assistance

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.
Frequent Visitor

## Re: Sum of average - Additional assistance

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