When Drilldown average of power bi calculation different with manual calculation(with calculator)

[vahid45]

When Drilldown average of power bi calculation different with manual calculation(with calculator).whats happen?

[Datatouille · Accepted 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."