Forum Discussion
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 287.23
Is there any blog or post which helps me to find that both column wise averages match.
appreciate your help, thank you
I was able to solve that by adding addin allselected on top value function. Thanks.
4 Replies
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.
Hi Amit,
The value turns out to be much lower using Averagex and Values.
can you suggest some other work around else please?
Measure = SUMX(VALUES(Cus_AgentPerformance[AgentName]),DIVIDE([Total],sumx(Cus_AgentPerformance,Cus_AgentPerformance[Inbound Calls])))Measure 2 = AVERAGEX(VALUES(Cus_AgentPerformance[AgentName]),DIVIDE([Total],sumx(Cus_AgentPerformance,Cus_AgentPerformance[Inbound Calls])))Thank you.
I was able to solve that by adding addin allselected on top value function. Thanks.
