Forum Discussion
Matrix wrong summation
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
the issue was in the master data I use for mapping the products and the customers.
Thanks alot all for your reply and help 🙂
6 Replies
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/547907sorry 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.14Mai_Nashaat Any chance you can share the PBIX? Do you have any filters on the visual or page or report as a whole?
the issue was in the master data I use for mapping the products and the customers.
Thanks alot all for your reply and help 🙂
