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. 🙏
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!
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!
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
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!!
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.
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.
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
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
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. 🙏
I've been looking everywhere for a good fix and this was by far the quickest and most practical!
Easy explanation. I've been trying to understand this for months, and didn't fully get it until watching your video today. THANK YOU.
:) you are welcome!
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!
Nice advice, i checked ma previous work and discovered that it summarized incorrectly, now i fixed it, thanks for it.
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...
Thank you so much, I shearched everywhere you were the only one to really explain it
absolutely the simplest and easiest to follow solution out there. Thank you so much for making this so easy!
Fantastic. Easy really when explained like that. You deserve more subscribers.
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!
You're very welcome!
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
Amazing tutorial and solution for the problem! Thank you!!!
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!!
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.
more are coming, stay tuned
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.
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
You're welcome!
BIG THANKS for the video, I ve been searching solution for that for a week...
glad it was useful!
Could you please do a video on ADDCOLUMNS in addition to SUMX? Thank you!
check out this video where I cover ADDCOLUMNS() th-cam.com/video/fmLWVkZplic/w-d-xo.html
Very nice and simple explanation ..Great teaching
Ya this is very usefull for me and one more here the margin % totals are incorrect how we can fix that % total values
Thank you so much!!! this video helped me a lot
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
sounds like you need to play with filters, but it's hard to say not knowing what the data looks like.
Great video. Can you please add some more video's on this where we get complexity
sure, can you suggest a scenario that you think would be helpful?
Awesome explanation. Thank you!
It worked. Thank you so much.
Thanks a lot!! It finally worked!
Awesome content and explanation. Thanks a ton for posting this video.
My pleasure!
God bless you. You are a life saver
Thank you! exactly what I needed to fix my problem
Glad it helped!
Thanks for the great video. BTW, the link to the blog post does not work.
it should be working now, ty for heads up
Thanks sir. Really helpful
❤️❤️❤️❤️❤️❤️
What works to correct totals on 3 month projected rolling forecasts? This removes my rolling projection.
Thank you! Super helpful and informative video
very welcome!
I have checked, and it will also work if we use sumx(table name , [commisn]) then whats the need of using "values". Please reply
All I can say is wow! and thanks!
Thanks a lot, it's a really helpfull content.
Congrats
You are welcome!
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
effectively, Values returns a new table with all of the unique values in the Rep column of the Sales table
Great video! Thank you!
You are welcome!
Thank you! that help me sooooo much
it's help me to complete my project man. Thank you!
Happy to help!
Thank you!
THANK YOU SOOOOOO MUCCCCHHHH :)
you are very welcome!
Amazing explanation, thank you.
glad it was helpful