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

No video

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

Рет қаралды 14,844

4 жыл бұрын

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...

Пікірлер: 63

@user-tr7br6zp3l 8 ай бұрын

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 3 жыл бұрын

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 3 жыл бұрын

:) you are welcome!

@Bigboy_T-1000 2 жыл бұрын

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

@oromega6469 9 ай бұрын

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!

@2409anand 2 жыл бұрын

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...

@Lotaristo 2 жыл бұрын

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

@user-iv5vh2mb6s 8 ай бұрын

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

@FulcrumKC 2 жыл бұрын

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

@jebbyjoseph7629 3 жыл бұрын

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 3 жыл бұрын

You're very welcome!

@ianpollard4138 2 жыл бұрын

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

@ewanstevenson4721 3 жыл бұрын

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

@sujatanadkarni8386 3 жыл бұрын

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 3 жыл бұрын

You're welcome!

@Niconico2 3 жыл бұрын

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 3 жыл бұрын

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 3 жыл бұрын

more are coming, stay tuned

@krishnaRaog21 4 ай бұрын

Very nice and simple explanation ..Great teaching

@husseinbdeir9214 2 жыл бұрын

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

@user-mg8jq4ec6e 2 жыл бұрын

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.

@rodrigomaximo1034 2 ай бұрын

Amazing explanation, thank you.

@KnowledgeBankPro Ай бұрын

glad it was helpful

@Adam-cd3xd 3 жыл бұрын

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

@KnowledgeBankPro 3 жыл бұрын

glad it was useful!

@harisrajput4434 Жыл бұрын

God bless you. You are a life saver

@ximena33440 2 жыл бұрын

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

@pavanreddy531 2 жыл бұрын

It worked. Thank you so much.

@venkatrathnam2305 2 жыл бұрын

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

@thehaijon Жыл бұрын

Thanks a lot!! It finally worked!

@saidaharle3637 3 жыл бұрын

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

@KnowledgeBankPro 3 жыл бұрын

check out this video where I cover ADDCOLUMNS() kzfaq.info/get/bejne/nNN8irmcv9bQmZc.html

@alizpunk 3 жыл бұрын

Thank you! exactly what I needed to fix my problem

@KnowledgeBankPro 3 жыл бұрын

Glad it helped!

@altcapital2472 Жыл бұрын

All I can say is wow! and thanks!

@orkhannazarov2781 2 жыл бұрын

Awesome explanation. Thank you!

@karthikak5149 3 жыл бұрын

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

@KnowledgeBankPro 3 жыл бұрын

My pleasure!

@kishanmatanhelia1221 2 жыл бұрын

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 2 жыл бұрын

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

@adnan.sarwar 3 жыл бұрын

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

@deepaka3820 3 жыл бұрын

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 3 жыл бұрын

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

@nagk7481 4 жыл бұрын

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

@KnowledgeBankPro 4 жыл бұрын

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

@CJ-jc8tn 3 жыл бұрын

Thank you! Super helpful and informative video

@KnowledgeBankPro 3 жыл бұрын

very welcome!

@kenw2086 4 жыл бұрын

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

@KnowledgeBankPro 4 жыл бұрын

it should be working now, ty for heads up

@fernandolazzarini3921 3 жыл бұрын

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

@KnowledgeBankPro 3 жыл бұрын

You are welcome!

@bravucod 4 жыл бұрын

Thank you!

@inga521 4 жыл бұрын

Great video! Thank you!

@KnowledgeBankPro 4 жыл бұрын

You are welcome!

@danielgagnon8201 3 жыл бұрын

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 3 жыл бұрын

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

@gokceyuksel4089 3 жыл бұрын

THANK YOU SOOOOOO MUCCCCHHHH :)

@KnowledgeBankPro 3 жыл бұрын

you are very welcome!

@fahmigasai 3 жыл бұрын

Thank you! that help me sooooo much

@fahmigasai 3 жыл бұрын

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

@KnowledgeBankPro 3 жыл бұрын

Happy to help!