topic Re: matrix total is not correct in DAX Commands and Tips

matrix total is not correct

Anonymous — Mon, 29 May 2023 12:13:31 GMT

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

Re: matrix total is not correct

eliasayyy — Mon, 29 May 2023 12:23:35 GMT

can you share a screenshot please?

Re: matrix total is not correct

Anonymous — Wed, 31 May 2023 06:17:54 GMT

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.