matrix total is not correct

[Anonymous]

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

[Anonymous · Accepted solution]

Hi @Anonymous ,

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?