Forum Discussion

Mai_Nashaat's avatar
Mai_Nashaat
Icon for Helper II rankHelper II
5 years ago
Solved

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 sh...
Need Help
  • Mai_Nashaat's avatar
    Mai_Nashaat
    5 years ago

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

    Thanks alot all for your reply and help 🙂

Mai_Nashaat's avatar
Mai_Nashaat
Icon for Helper II rankHelper II
5 years ago

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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

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's avatar
    Mai_Nashaat
    Icon for Helper II rankHelper II
    5 years ago

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

    • V-lianl-msft's avatar
      V-lianl-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      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.