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.