matrix total is not correct

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.