Total AVG is wrong

[tuulia]

Hi! I have read tens of community messages about wrong totals but I can't find an answer

I have a simple table with average salaries (full year). Measure is "AVERAGE(salary[sum])". Employee averages are correct but total is wrong. Report is filtered by "year" and "full/part-time"

Sample-data

How do I fix this total-row?

[tuulia · Accepted solution]

I think this problem is related to rounding of sums behind average

[Anonymous]

Hi @tuulia ,

I cant replicate the problem. 

Can you expand your sample data a bit more (with the year and fulltime/aprt time columns)?