Using ALLEXCEPT vs ALL VALUES

ALLEXCEPT is a handy DAX function to retrieve all the columns of a table except for some. When used as a CALCULATE modifier, its behavior is less intuitive and might result in inaccurate measures. In this video, we elaborate on the most common mistake when using ALLEXCEPT in CALCULATE.

[kamalverma]

There can't be a better explanation than what you have taught us Alberto. Much appreciated.

[pravinupadhyay]

Guy in a cube + SQL BI = Everything about Power BI and DAX.
I started learning DAX on Power pivot model by reading your 1st version of book " Definitive guide to DAX" I have also read the 2nd version which is more specific to Power BI,
Thankyou very much for your great guidance.

[joaorataoo]

When I watch your videos I'm always divided on what I admire most about you: your knowledge or your ability to explain.
Thank you so much Alberto.

[adriancritchley]

This is such a perfectly explained example, that not only clarifies how and when to use each function, but also helps me to understand filter context in DAX generally.

[joeseroski]

I love how you walked through the Filter context with comments in the Measure. That helped my understanding.

[evedickson]

Absolutely brilliant... watching this video has saved me so much time trying to resolve an issue... the best DAX content available 👌

[ImranHussain-xvse]

Long live Alberto, you are guiding light for many power bi learner.

[Patiencelad]

Thanks so much! I was having the hardest time creating a daily % of total calc with a slicer. The Internet (searched several hours) said it couldn't be done, but your REMOVEFILTER trick worked.

[mwaltercpa]

I like how you typed the outer / inner filters in the comments of the measure. Very helpful to visualize those elements. Also summarize for multiple restored col is helpful!

[teunkruijer]

I feel like a criminal watching these videos for free. Hands down best Power BI/DAX tutorials on youtube. Thanks again Alberto.

[samikpal]

Could have never made sense of DAX on the granular level without SQLBI. Thanks for peeling the layers of DAX for us.

[rachelrdyer]

This is such a fabulous video, not just for the topic content, but because how elegantly it explains how to think about the solution, including the comments added to the code to help see the filter context. Thank you so much Alberto!

[shadrackawunyo]

Thank you very much Alberto. I spent 2 days trying to get a similar result in my report. You have saved me.

[szklydm]

I cracked my head for a time around the exact same problem until I somehow figured out the REMOVEFILTERS & VALUES solution :) So good to see it from the masters as well!

[kot]

I've seen several videos on this topic and, Alberto, you have superpowers on explaining and making things clear! Thanks!

[rohithdevatha]

Very helpful. I have been using ALLEXCEPT for so long and been facing some problems. This approach of Removefilters and Values is so easy and better

[BISimplifier]

Best."Table vision" explains clearly.

[mihretnetsereab]

Wow Alberto you are something. I am obsessed with your videos. I love the way you explained it and the way you wrote your code is fantastic. Thank you

[gernotkralits]

The best explanation of filter context I've seen yet - great work and keep it up, please!

[raniakkina]

Thanks a lot Alberto. You beutifully explained every scenario.