Forum Discussion
Helper ITotal average in PBI table is not correct
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.
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.
MarcinSVOf course!!! I was trying to calculate average from average :)
And its a difference like in example:
select (1+2) / 2. = 1.5
select (1+2+3) / 3. = 2
select (1.5 + 2) / 2 = 1.75 -> AVG from AVG
select (1+2+1+2+3) / 5. = 1.8 -> correct AVG
Thank's for help in showing the way :)
Hello,
do you find the solution?
I have the same problem.
I don't know how to calculate average of averages.
Thanks in advance.
- MarcinSV
Calculating 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 AVGSo it's not an error of PBI but mistake in calculating average from average (1.75 vs 1.8 on above example).