Matrix not summing row and column totals correctly?

[Anonymous]

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!

[v-yiruan-msft · Accepted solution]

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]

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