matrix total is not correct

[Prajakta11]

hello my spends total measure is made up of multiple different measure ,but if I try to get it on matrix it is not givint me correct total ...please help

[v-rzhou-msft · Accepted solution]

Hi @Prajakta11 ,

Due to I don't know your data model, I will create a sample to show you how to achieve your goal.

Sample:

Measure:

Average = AVERAGE('Table'[Sales])

Average with correct Total = 
SUMX(VALUES('Table'[Category]),[Average])

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[eliasayyy]

can you share a screenshot please?