Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Matrix not summing row and column totals correctly?

Hello,

 

I have a matrix set up to show hours of downtime planned in a year. For some reason I cannot get the hours to sum correctly. Any idea why this is.

 

Thanks!

bhai-ali_0-1594413630739.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous ,

You can refer the solutions in the following links to get the correct total value:

Totals incorrect

Why Your Total Is Incorrect In Power BI

If the above ones still can't help you get the correct results, please provide some sample data(exclude sensitive data) and expected totals. Thank you.

Best Regards

Rena

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @Anonymous ,

You can refer the solutions in the following links to get the correct total value:

Totals incorrect

Why Your Total Is Incorrect In Power BI

If the above ones still can't help you get the correct results, please provide some sample data(exclude sensitive data) and expected totals. Thank you.

Best Regards

Rena

jdbuchanan71
Super User
Super User

@Anonymous 

It has to do with the way your measure is written and the evaluation context for the totals row and column.  Take a look at this article, it talks about how to get the totals you are expecting.

https://www.sqlbi.com/articles/obtaining-accurate-totals-in-dax/

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors