Maxtrix show data Incorrect

[nmhung49]

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

[Uzi2019 · Accepted solution]

Hi @nmhung49 

Just modify your relationship

Connect Doc No with Sales and SAP

Sharing pbix for reference.

I hope I answered your question!

[Uzi2019]

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.

[nmhung49]

I edited link to download file