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!
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...
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!
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!
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.
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!
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!
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!
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 RU-vid 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/ ru-vid.com/show-UCy2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
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 RU-vid 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/
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.
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
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.
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
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 :/
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 RU-vid 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/
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 RU-vid 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 ru-vid.com/show-UCy2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/