Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
When Drilldown average of power bi calculation different with manual calculation(with calculator).whats happen?
Solved! Go to Solution.
Hi,
I don't know how this average is computed but the total '3887' seems to be correct.
3522 would be the 'average of the averages' but it is mathematically not correct.
Example:
(a + b + c) / (d+e+f) is the correct average and is different from (a/d + b/e + c/f) / 3.
R.Kimball summarized the calculations of ratios (and thus averages) in one (perfect) sentence:
"You should aways do the ratios of the sum rather than the sum of the ratios."
Hi,
I don't know how this average is computed but the total '3887' seems to be correct.
3522 would be the 'average of the averages' but it is mathematically not correct.
Example:
(a + b + c) / (d+e+f) is the correct average and is different from (a/d + b/e + c/f) / 3.
R.Kimball summarized the calculations of ratios (and thus averages) in one (perfect) sentence:
"You should aways do the ratios of the sum rather than the sum of the ratios."
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |