Absolutely the best DAX educator.

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

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.

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.

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.

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

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

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

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!

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

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

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.

Nice explanation. Thank You. Dax really needs this kind of step by step in-depth explanation.

I cracked my head for a looooong 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!

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!

Thank you very much. Great explanation. Simple and capacious.👍

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

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

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

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

Thanks Alberto!!! You are the best in explaining DAX. The way you explain is awesome. Best in the business.

Thank you for taking the time to produce these instructional videos and publish them. You are the best!

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

This explanation has been an ABCD, absolutely your are great!!!!

Best."Table vision" explains clearly.

Ótima explicação Alberto. Você é o melhor professor de DAX da Internet....

Crystal clear! Thanks for the video. Learning something new about using SUMMARIZE as the filter modifier. Great. :)

I like this content and it saves my learning time on uncertain on many youtube sites.

This was such a timely video for me as i was struggling with this very thing right now, many thanks. 🤗

Thank you for your great pedagogical explanations Alberto!

Outstanding explanation!!!

As always we don't stop learning from you,Thank a lot

The best video that I have ever seen

Awesome explanation and example 😊

Many thanks Alberto. I love the way you explained in this video.

thank you for this video. you explain dax so logically and i have learnt so much from your videos!

It solved the issue I had with ALLEXCEPT! Great video!

The beginning Intro summary is so helpful preparing laying the framework with details to be filled in :)

Very very well explained, thanks a lot for the quality of the example and the logic!

Alberto thanks a lot .Perfect & accurate explanation, as usual .

Absolutely Super and brilliant!!

Now I understand my mistake. Thanks sqlbi.

Thanks a lot u saved a lot of my time I am working on migration project and there is a scenario of fixed lod

Great explanation Alberto you have lots of magic thing great and thanks to share with us your ultimate knowledge and very highly effective tricks.

Thanks for showing the alternatives!

Really helpful! Thank you so much!!!

Thanks for the informative video.

Utterly brilliant. Seriously considering your course on Mastering/optimizing dax

Sir as always you are the superb master. Namaste🙏

Best of best explanation

Very clear to me.

Very good example, thx a lot

Conclusion for this use case. ALLEXCEPT(Continent) depends on the filters applied to the visual. Thus, it can break if the 'Continent' drill disappears. A better, more robust option, is to enforce the Continent filter using REMOVE FILTERS(Country) + VALUES(Continent).

super smart, best explanation, thank you very much for sharing

Hello Loved this one. Though my dying situation is that I want to keep the filtes which are passed with drill trhough and on top of that I want to apply a topn filtes specific for a category and this also needs to give right number of rows when export in Excel

Thanx Alberto.

Great video! Very informative and easy to follow!

Thanks a lot! Very clear

Great Video. Thank you

This guy is great!!!

thanks a lot, huge gug from Colombia

Alberto you are a genius

Very nice! Thank you for this video!

Thank you for the video but more for article , I recently wrote two formulas one ALLEXCEP the Other ALL and VALUES, and have been trying to understand why ; ALL and Values; RTM All and Values 2 := CALCULATE ( [Tsales], FILTER ( ALL ( Table1[Date] ), Table1[Date]

I only see the surface. Thank you for showing us the depths of DAX

Clearly explained. Thank you 👍

Awesome video

Very well explained. Thank you.

Wao excellent explanation

Simply amazing! Thank you

Thank you!!!!

thank you!

Grazie Alberto 👌

THANK YOU!!!!!

OMG you just solved my week-long problem, thank you!!! Where can we donate, I'd like to give to you as a sign of thanks for solving my problem !!!!!!!

Maestro !

ALLEXCEPT() removes all filter, except columns specified. REMOVEFILTER() and VALUE() is a better alternative.

I wished to have your dax knowledge.

thank you.

you are amazing!

Phenomenal :)

Thank you! Very clearly explained, it really helps beter understanding DAX. One question, in the end result I see a problem I have often and can’t solve most of the time. It shows a total of 100 for percentages but because of the filter it is not correct in this context. How best to not show it if it is not the actual total?

Perfection

Hi Alberto very good explanation Thanks But I have question if I have multiple hierarchy category like : countryxcategory, category , product, sales amount I want to show the sum of sales amount by countryxcategory . And if I apply the filter in slicer by product or any field from table it should show the sum of sales amount by countryxcategory like you show in video And it should not change the total amount but category if I apply any filter and slicer on category product but this logic cannot work can you tell me why?

legend.

Mr. Alberto. Good Evening. I do need to represent two Curves in my PBI report, Plan and Actual, using the example above I created the plan curve easily even using a modifier it came out 100% perfect. But how can I make the second one and place it in the same visual? If I do the same I will have both showing 100% which is not right. Plan = 100% / Actual = 65% Plan = 95% / Actual = 63% and so on..... I really need your expertise on this. Thanks in advance.

REMOVEFILTER is not available in Excel DAX, i have solved using All function. . VAR SelSales = [Sales Amount] VAR ContinentSales = CALCULATE(Sales[Sales Amount],ALL(Customer), SUMMARIZE(Customer,Customer[Continent])) VAR Result = DIVIDE(SelSales,ContinentSales) Return Result

🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥

Many Thanks...

thank you so much, I was very confused, so with your explanation, right now I have clear the difference between them. but instead of "remove filters" you could use "ALL" as well, Right?

When there is no filter context present on Continent and hence ALLEXCEPT makes filter context null, you mentioned that Sales Amount is of entire world. So by that logic % for France should have been 100%. Having said that, I am certainly missing something, but unable to figure out what is that I am missing. Can you please help?

Great video, as usual 😊 Please, I have a question: if a slicer filters by Gender or Age (ie by a column of the Customer table), how can I keep its filters? My solution is the following PercOverContinent 100% = VAR SelSales = [Sales Amount] VAR ConSales = CALCULATE ( [Sales Amount], ALLSELECTED(), VALUES (Customer[Continent] ) ) VAR Result = DIVIDE ( SelSales, ConSales ) RETURN Result It's OK? Is there a better way to accomplish this? Are there any videos addressing this issue? Thank you

i have created a same data set in test power bi desktop file but it is not working here i dont know why

Thnank you for the explanation! you make it look so easy! I would have one follow up question, if possible. I found that this formula also seems to work: High month TRY = sumx(VALUES('Date'[Calendar Year Month]), CALCULATE([Is high month], ALL('Date'[Date]))) Is it because we remove the filter conext on the day? but we are left with the year/month context?

Please can you do a video about 'PLACEHOLDER" error in DAX. Thanks!

My Detail message is not showing here i dont know why ? i have query and i am struggling with this logic .

Thank you very much, this is really clear. In this pattern, is it possible to replace VALUES with DISTINCT? Thx

Hi @alberto ferrari, can you please share me the data model which you are using here ?

When exactly ALLEXCEPT is useful then?

why u have only 93k subs till now... i think no1 want to take knowledge... only showoff techniques..