cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## 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?!

Mai

1 ACCEPTED SOLUTION
Helper II

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

6 REPLIES 6
Helper II

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

Super User

@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/547907

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Helper II

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
Super User

@Mai_Nashaat Any chance you can share the PBIX? Do you have any filters on the visual or page or report as a whole?

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Helper II

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

Community Support

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors