DAX Fridays! #152: ALL vs ALLEXCEPT

In todays video we will go through the differences between all and allexcept dax functions.

SUBSCRIBE to learn more about Power and Excel BI!

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

▲▲▲▲▲▲▲▲▲▲

Our PLAYLISTS:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#daxfridays #curbal #SUBSCRIBE

[tiffanyharris]

You just stopped my hours and hours of madness this morning. Thank you!!! Please continue posting these types of videos. They are so helpful. I rewatch them over and over.

[andreashermle]

Thank you very much for the insight into this function. The best explanation so far I have watched on YouTube. Keep up the good work!

[hasnainhaider]

I've been taking many tutorials on power bi via youtube from many other people as well. But watching your video, it seems as we are in front of another, and learning from you directly. Above all, you explain things from the very beginner level perspective. Kudoos!

[ashwinkarki]

Your explanation si so clear with such great example. I was so confused regarding allexcept and all fucntions. And this video saved my night. Really thank you.

[markmcc]

As ever Ruth 2 mins into the video and I understand something i spent an hour on Microsoft documentation trying to get my tiny brain to understand! thanks again!

[lindabond]

Ruth - tu sei grande! Magnifica! Grazie!

[TheFootballRef]

I think I am in love with you, Curbal - honestly.

[Phoenixspin]

The lady in the thumbnail looked all perplexed but that was BEFORE she watched this video. Now she understands. It even now makes sense to me. Thanks, Ruth.

[lenanguyen]

Hello! Thank you so much for this video. I have a question need your help if you will please. How can I show sales of USA only for all rows, regardless of other countries, but still keep other filters from my slicers?

[aliramadan]

Great Video Ruth. I was always confused when to use which. Thank you!

[kamranb]

Another great video, I love your channel Ruth

[christinelowery]

How can I use it to apply to provide sales per week using week number column. I tried allexcept week number but it still sums by category

[seenureddy]

we can use All Dax and remove the filter of a column, then what is the use of ALL EXCEPT. Please explain.

[krdhuri]

hi I am using Direct Query mode for almost 1 billion rows, I want to apply filter on a column location here but when i create a measure i need to ignore filter. I have used ALL function like CALCULATE(SUM(Sales[Amount], ALL(Sales[Location])) but it is taking 30-40 seconds. Is there any way i can optimize this DAX?

[chavelooo]

Hi Curbal, thank you very much for your videos, this one is very useful, I got the following situation.
I need to iterate 3 columns (Qty * weight * assembly category) where Assembly category has two descriptions: Batter & Packaging and I need to get rid of packaging in the iteration. Packaging is inside the column assembly category. Do you have any video or hint that can possibly help me with the solution. Thank you very much for your time and help.

[MichelleMason]

Hi Ruth, my undersatnding is that ALL and ALLEXCEPT *include* all, in direct contradiction to your tutorial. It ignores filters in place. I'm confused.

[RobertoStaltari]

Ruth is gifted. Makes complex stuff looks easy! But still they are complex :'( Thanks Ruth!

[SunilKumarMutte]

Hi, first thing I would like appreciate for the video, making me to understand ALL VS ALLEXCEPT,

I have a doubt, now I have a column "Gender" from another table "customers", if there is a slicer with gender, when I filter with slicer data is getting updated in the table, so please clarify how to avoid filtering from another table also?
Thanks in advance

[parisaayazi]

Reminder to myself: watch one of her video everyday!

[husspirit]

Hi,
If i have 2 allexept in the calculate formula, does the order matters ? Example :
Allexcept(city ),
Allexept( country ) is different from Allexcept(country ),
Allexept( city)