Forum Discussion
How to sum a total average column
Hi,
I have created a table to calculate the average from a list of values. Following this I want to sum the average of the values together. However, when you use the subtotal function it calculates the average of the values rather than the sum e.g. the average is 2285.46 ( shown below) the value I want it to show is the sum 8276.84.
Any help appreciated, thank you!
5 Replies
Hello! Give this a whirl:
SumOfAverageVolume =
SUMX (
VALUES ( 'Table'[GroupColumn] ), -- Replace 'Table'[GroupColumn] with your actual table and group column
[average of volume of Ctrl 1]
)hi, thanks for the advice, i tried this but there are multiple values that make up the average so when its sums the average together it adds all the values and gives a much larger number.
is there no way for it to just add the values up from the average of 'Average voume of ctrl 1' column so it would add up to 8276.84.
Also the 'Average voume of ctrl 1' isnt a field in my table its when i select volume of ctrl 1 field and change it to average. Hope this makes sense and thanks in advance.Hi,
Write these measures
Average = average(Datap[Volume of Ctrl 1])
Measure = SUMX(VALUES(Data[Source]),[Average])
Hope this helps.
