Average not being calculated correctly

[Anonymous]

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 is incorrect. However, min and max are correct and average for other income groups are correct.

When I don't summarize it the values are coming correctly only as below:

The average should be 470 as per this: total/3. Only with average there is an issue.

Anyone has a clue?

Thanks in advance!

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed, so that more people will benefit from it.

Thanks in advance!

Best Regards,
Eyelyn Qin

[Anonymous]

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.

[vanessafvg]

what is your calculation for average?

[Anonymous]

@vanessafvg I an not using any calculation. I am just using value as average as below: