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.
Go to Solution.
Hi @bhai-ali ,
You can refer the solutions in the following links to get the correct total value:
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.
View solution in original post
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.
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.