Forum Discussion
Average not being calculated correctly
Hi, I have created a table and only the average of one group is not being calculated correctly. I am unable to identify the issue. Below is the table the average for Employed and Social Welfare i...
Hi Anonymous ,
It does work on my side.
How about using the AVERAGE() like this:
Measure = CALCULATE(AVERAGE('Table'[Weekly Income]),ALLEXCEPT('Table','Table'[Income Group]))
If it does not make sense, please share me with your pbix file after removing sensitive data so that I could have a try again.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.