Forum Discussion
Solved
Average
Hi, Can you help me why Power BI shows different average to correct average. 1st screen shot shows excel average to be 271.6 2nd screen shot shows Power BI where average for column shows as 28...
I was able to solve that by adding addin allselected on top value function. Thanks.
DeeMag , If you have used a formula
Sum(A)/Sum(B)
Power bi will recalculate the grand total by summing up the A and B
In the case of excel, it is a simple avg of rows
in power bi you can get that like
averagex(Values(Table[Agent name]), Divide(Sum(Table[A]), Sum(Table[B])))
Where Table[Agent name] is column on which data is grouping for avg
Thanks Amit, i will try the way you suggested.