Forum Discussion

nmhung49's avatar
nmhung49
Icon for Helper II rankHelper II
2 years ago
Solved

Maxtrix show data Incorrect

I have maxtrix with relationships in Model. But it shows incorrect data. I want column TotalSAP = TotalSale. I think I made the relationship wrong so the results were not as expected. I hope everyone can help me. Thank you

Attach File

 

 

 

Need Help
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    Hi nmhung49 

    Just modify your relationship

    Connect Doc No with Sales and SAP

     

    Sharing pbix for reference.

     

    I hope I answered your question!

     

     

3 Replies

  • Uzi2019's avatar
    Uzi2019
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi nmhung49 
    file you are attaching is required permission. that's open source file.

     

    did u create total sale or total sap as a formula??
    share open url for downloading pbix.

     

     

  • Uzi2019's avatar
    Uzi2019
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi nmhung49 

    Just modify your relationship

    Connect Doc No with Sales and SAP

     

    Sharing pbix for reference.

     

    I hope I answered your question!