Forum Discussion

tuulia's avatar
tuulia
Helper IV
3 years ago
Solved

Total AVG is wrong

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?

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi tuulia ,

    I cant replicate the problem. 


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

     

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