Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
I was able to solve that by adding addin allselected on top value function. Thanks.
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
Hi Amit,
The value turns out to be much lower using Averagex and Values.
can you suggest some other work around else please?
Thank you.
Thanks Amit, i will try the way you suggested.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
142 | |
111 | |
108 | |
99 | |
95 |