How To Fix Matrix Totals In Power BI

[@EnterpriseDNA]

Level up your Power BI skills and learn from industry experts around the globe! Check here for more info: enterprisedna.co/membership

[@fdm505]

Your video clearly explain how to resolve issues with incorrect matrix visualization totals in Power BI. This is the best video (or article) I've seen on this topic. I'm currently working to resolve a similar issue with incorrect matrix totals and now I should be able to get it resolved. Thanks!

[@danielsiffredi8403]

Great video Brian! I remember that case like it was yesterday and one thing I've learned after dealing with it was to create virtual tables to do whatever I needed to do, and get the exact result/total I need. Very well explained!

[@brianjulius6401]

Thanks! Great seeing you here - that problem was fascinating start to finish. Everything that I yada yada'd through here to get to the totals portion was really interesting too. Perhaps another video down the road...

[@gileswhalley]

Hi Brian, I think this is one of the best videos on the subject. It certainly helped me understand the issue and how to address it. Thanks for the upload.

[@EnterpriseDNA]

Hi giles, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@UlyssesHaq]

This video is pure gold dust! Sometimes totals behave, other times.. they are the devil! THANK YOU!

[@brianjulius6401]

Thanks so much for the feedback! Fixing totals in Power BI is by far the most common problem we get on the forum, so I was hoping to provide some useful tools/approaches to help users work through that issue. Glad to hear that you think I hit the mark. Thanks for watching!

[@sathyaruba4405]

Great! Its working for me so cool.This is the best video for matrix total issue

[@mieproductions6209]

What can you do if you only have 1 value but you still want to calculate the sub-total differently? In this case, both the subtotal has one value and the row/column context.

[@powerbidesign7011]

wowow that was really helpful !!! thanks you guy are genius

[@EnterpriseDNA]

Hi, glad you found this video helpful! If you haven't yet, you can subscribe to our channel to see all our upcoming tutorials and announcements. Cheers!

[@Leticiagc21]

Hi, I have a question, what if I have 2 rows and 1 column, how do I correct those values, because when I create a measure and insert it to a matrix, the row on top add its results with the one below :/

[@EnterpriseDNA]

Hey Leticia, It's a bit difficult to assess and recommend without looking at the data structure, model and working of the PBIX file for reference. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZbin channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

[@gatgreene1338]

Helpful but the load time for a large data set is certainly an issue when using this formula. Do you know any workarounds for load time issues?

[@EnterpriseDNA]

Hi @gatgreene1338, It's a bit difficult to assess and give recommendation without looking at the data structure, model and working of the PBIX file for the reference. You can reach out to us on our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZbin channel and LinkedIn group to keep posted on the latest data skills and tools updates. Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

[@1yyymmmddd]

Sometimes PBI wouldn't show totals even in a table visual that doesn't use measures, just dropped-in fields. Curious - why is that?

[@EnterpriseDNA]

Hello obj, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. That could be because the settings of that field may have been set to "Don't Summarize" or the totals are set to off. Please check these settings in your Power BI report. As an important note, it's never a recommended practice to use the fields directly into the report and rather should be used in the form of measures. Please refer our best practices video for the reference. For furthermore queries, you can also reach out to us onto our Community Forum by providing a proper description of the query along with the reference mock-up files to work on, where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful! If you haven't yet, you can subscribe to our KZbin channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@borislavjovanovic8190]

Hello. What would be approach If I need to have Measures as columns, and in a Row section of Matrix is Year Hierarchy (Year /Month), so values are per month and need Totals per year, but not showing. I tried your approach, not working? Thank you in advance.

[@eddieeales5699]

Fantastic, thanks Brian .. and very well explained!

[@EnterpriseDNA]

Hi Eddie, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!

[@mileruiz1]

Thank you very much, this is super helpful!

[@xThijsHD]

How can I replace BLANKS with 100? And keep the blank rows in the calculation?

[@matheusassumpcaosolinho5883]

Someone knows how can i adjust the formula when i have 2 row levels and 2 columns levels ?

[@EnterpriseDNA]

Hi Matheus, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful! You can subscribe to our KZbin channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@tanababa]

Hi, thank you for the great video/tutorial. It helped me solve a similar scenario. Is there a meaning to the "@" sign in the DAX code? I tried giving a name without the "@" sign and it failed

[@NirRobinson]

Great video! Thanks. Can we solve the same with summarise?

[@brianjulius6401]

You absolutely could. There's so much flexibility and power in the DAX table functions that most problems like this one can be solved in multiple ways, and a really common pattern for addressing incorrect totals is to nest SUMMARIZE within the table argument of SUMX.

[@SergiyVakshul]

Hi, I would comment VALUES( Opportunities[Period] ) line in "//Condition B - force column totals" block and "VALUES( Dates[ShortMonth] )" in "//Condition C - force row totals". They are superfluous

[@brianjulius6401]

Thanks - nice catch! This does simplify the final measure. I'll address this at the end of my next video.