Power BI & DAX: What to Do When Power BI Totals are Wrong

Have you ever gotten yourself in a situation when your calculation works great on a row by row basis, but when you look at a total, it does not match to the SUM of the individual rows?
If so, the problem is not Power BI, the problem is in your calc. The good news is that it’s usually very simple to fix this issue. I go over a possible way to fix it in this video.
Link to SUMX() video: • Power BI: Getting Bett...
Link to blog for this video with code samples: businessintell...

[@IlafHashim]

I searched EVERYWHERE and read and tried to solve my problem for hours and then I found your video and I finally understood. THANK YOU!!! Clear, concse and simple explanation. 🙏

[@cstevens36]

Easy explanation. I've been trying to understand this for months, and didn't fully get it until watching your video today. THANK YOU.

[@KnowledgeBankPro]

:) you are welcome!

[@Bigboy_T-1000]

I've been looking everywhere for a good fix and this was by far the quickest and most practical!

[@oromega6469]

Really enjoyed the approach of having the measure that initialy fails as the second input parameter. Gives you good control on the row interation method!

[@Lotaristo]

Nice advice, i checked ma previous work and discovered that it summarized incorrectly, now i fixed it, thanks for it.

[@JohnVasconcelos-d4v]

Thank you so much, I shearched everywhere you were the only one to really explain it

[@2409anand]

A week's time that I had wasted before watching this video was my fate!!!!!! TILL I GOT TO THIS VIDEO....thanks a ton for an easy explanation...

[@FulcrumKC]

absolutely the simplest and easiest to follow solution out there. Thank you so much for making this so easy!

[@jebbyjoseph7629]

hi - i hope that you are well. Thank you so much for this video. I have been puzzling over this problem for a while at work and this video has solved my issue. I tried countless other methods which did not yield the desired outcome, but this solution worked great!

[@KnowledgeBankPro]

You're very welcome!

[@ianpollard4138]

Fantastic. Easy really when explained like that. You deserve more subscribers.

[@sujatanadkarni8386]

Excellent ! better than one has filter option - simple and less tasking - relieved a lot of stress - was struggling with it for quite some time. Thanks

[@KnowledgeBankPro]

You're welcome!

[@Niconico2]

thanks!! good explanation, in my case i had to do a double sumx, telling to power bi first calculate the sum row by row for articles, and then for sellers, and it worked perfectly!!

[@Niconico2]

that was because in the same table i had 2 o more times the same articule, for different seller, then the sum was still wrong. This easy sumx saved me, buy i would like to see more of those harder solutions that you said at the end of the video.

[@KnowledgeBankPro]

more are coming, stay tuned

[@ewanstevenson4721]

Thanks for posting this. So many ways to do this but I like the idea of SUMX over VALUES. I keep forgetting to use VALUES. I'll look at some more of your videos. Ewan Stevenson, London UK

[@Adam-cd3xd]

BIG THANKS for the video, I ve been searching solution for that for a week...

[@KnowledgeBankPro]

glad it was useful!

[@husseinbdeir9214]

Amazing tutorial and solution for the problem! Thank you!!!

[@ximena33440]

Thank you so much!!! this video helped me a lot

[@krishnaRaog21]

Very nice and simple explanation ..Great teaching

[@thehaijon]

Thanks a lot!! It finally worked!

[@pavanreddy531]

It worked. Thank you so much.

[@harisrajput4434]

God bless you. You are a life saver

[@karthikak5149]

Awesome content and explanation. Thanks a ton for posting this video.

[@KnowledgeBankPro]

My pleasure!

[@alizpunk]

Thank you! exactly what I needed to fix my problem

[@KnowledgeBankPro]

Glad it helped!

[@南賢準]

THANKS A LOT. im new to powerbi, there is onething i can't understand that why SUMX can sum the cloumn not in arg1.Arg1 is distincted cloumn with name but no number.

[@venkatrathnam2305]

Ya this is very usefull for me and one more here the margin % totals are incorrect how we can fix that % total values

[@orkhannazarov2781]

Awesome explanation. Thank you!

[@adnan.sarwar]

Thanks sir. Really helpful ❤️❤️❤️❤️❤️❤️

[@altcapital2472]

All I can say is wow! and thanks!

[@saidaharle3637]

Could you please do a video on ADDCOLUMNS in addition to SUMX? Thank you!

[@KnowledgeBankPro]

check out this video where I cover ADDCOLUMNS() kzbin.info/www/bejne/nJ6viImhj9Wfn8U

[@CJ-jc8tn]

Thank you! Super helpful and informative video

[@KnowledgeBankPro]

very welcome!

[@fernandolazzarini3921]

Thanks a lot, it's a really helpfull content. Congrats

[@KnowledgeBankPro]

You are welcome!

[@deepaka3820]

Thank you. it works at the main row level. What should I do if I have a collapsed sub row within the main row? I am now referencing the main row in sumx(). I need the total below at sub row level

[@KnowledgeBankPro]

sounds like you need to play with filters, but it's hard to say not knowing what the data looks like.

[@kenw2086]

Thanks for the great video. BTW, the link to the blog post does not work.

[@KnowledgeBankPro]

it should be working now, ty for heads up

[@nagk7481]

Great video. Can you please add some more video's on this where we get complexity

[@KnowledgeBankPro]

sure, can you suggest a scenario that you think would be helpful?

[@fahmigasai]

Thank you! that help me sooooo much

[@fahmigasai]

it's help me to complete my project man. Thank you!

[@KnowledgeBankPro]

Happy to help!

[@inga521]

Great video! Thank you!

[@KnowledgeBankPro]

You are welcome!

[@kishanmatanhelia1221]

I have checked, and it will also work if we use sumx(table name , [commisn]) then whats the need of using "values". Please reply

[@cottinball80]

What works to correct totals on 3 month projected rolling forecasts? This removes my rolling projection.

[@bravucod]

Thank you!

[@danielgagnon8201]

Does values (sales[Rep]) reference the expanded table? Because if you evaluate it as a new table, it only returns John, Tom. Thanks in advance

[@KnowledgeBankPro]

effectively, Values returns a new table with all of the unique values in the Rep column of the Sales table

[@gokceyuksel4089]

THANK YOU SOOOOOO MUCCCCHHHH :)

[@KnowledgeBankPro]

you are very welcome!

[@rodrigomaximo1034]

Amazing explanation, thank you.

[@KnowledgeBankPro]

glad it was helpful