Matrix wrong summation

[Mai_Nashaat]

Hi everybody,

I use matrix to display data for products and their sales, the total of orders in the matrix is wrong however when I exported the data from the matrix and get their sum in the excel sheet it was right, where's the issue?!

Thanks in advance,

Mai

[Mai_Nashaat · Accepted solution]

the issue was in the master data I use for mapping the products and the customers.

Thanks alot all for your reply and help 🙂

[Greg_Deckler]

@Mai_Nashaat This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[Mai_Nashaat]

sorry I didn't get the point.

I've a simple measure just sum without any filters 

Open order SU sum = SUM('ZSKU SMO'[Column 2])

the total in  the matrix is 11.1 however in the exported data it's 13.14 

[Greg_Deckler]

@Mai_Nashaat Any chance you can share the PBIX? Do you have any filters on the visual or page or report as a whole?

[Mai_Nashaat]

@Greg_Deckler I can't it is confidential data but I have no filters

[V-lianl-msft]

I suspect this error caused by table relationship. If you can represent your data model with dummy data and share a sample pbix, we can do more tests to troubleshoot.