Forum Discussion
MarcinSV
Helper I
Helper ITotal average in PBI table is not correct
Hi, I don't understand why average in total is not correct, using standard table in powerbi. In rows values are group by customers correctly (as average): Customer A | 17,44 Customer B | 4,09 ...
This is the expected behaviour. The total average will not take an average of the averages per customer. The total average will take an average from the original data.
Hello,
do you find the solution?
I have the same problem.
I don't know how to calculate average of averages.
Thanks in advance.
MarcinSVHelper I
Helper ICalculating average from average its not a good idea because:
select (1+2) / 2. = 1.5 -> this is average
select (1+2+3) / 3. = 2 -> this is average
then if you calculate avg from avge you have: select (1.5 + 2) / 2 = 1.75 -> AVG from AVG
but proper calculate is: select (1+2+1+2+3) / 5. = 1.8 -> correct AVG
So it's not an error of PBI but mistake in calculating average from average (1.75 vs 1.8 on above example).