Solved: Grand Total In power BI matrix doesn't match

punnas1 · ‎02-04-2020

Hi,

I have a Table and the grand totals for a measure dont match up when i do manual.

Error Image

v-shex-msft · ‎02-04-2020

HI @punnas1,

It sounds like a common total level calculation issue, please check below blog to know more about this:

Measure Totals, The Final Word

If above not helps, please share some sample data to test:

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

v-shex-msft · ‎02-04-2020

HI @punnas1,

It sounds like a common total level calculation issue, please check below blog to know more about this:

Measure Totals, The Final Word

If above not helps, please share some sample data to test:

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

amitchandak · ‎02-04-2020

Share the formula, when it has something to do with row context it can happen

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Grand Total In power BI matrix doesn't match

Helpful resources

Power BI Monthly Update - October 2024

Microsoft Fabric & AI Learning Hackathon

Fabric Community Update - October 2024