Optimizing nested iterators in DAX 

I can't belive these awesome videos don't even have ads,

I like your video even before watching it. SQLBI is my favourite thing on internet. - a DAX and MDX fan.

So much clarity presenting complex solutions with simple approaches.

Watching this kind of videos, I'm pretty sure theat video courses and the books are the best investments I ever made! Thank you!

Thank you Alberto, the whole video is great, but the final trick, when you change the code to made it work with only one iteration is fantastic

Thank you Alberto for such a clear and thorough lecture! It is just awesome

Unbelievable useful lesson. Thank you, professor Alberto.

Great video, awesome that you share your knowledge openly like this!

thank you, Alberto this video goes so well with reading the chapters on calculation context, Calculate, and context transition in the Definitive Guide to DAX!

Thanks Alberto.

Amazing!! Excellent video and explanation. Thank you very much

Simply awsome. You are indeed a DAX Super Guru.

Ciao Alberto! I love your: This is always dangerous! :) Good video as always!

Enjoying DAX! Thank you 👍

Thanks a lot Alberto! Great video!

That's beautiful! Really amazing

Awesome !!! Appreciate that you contribute a lot to all over the world world 🌍🌍🌍🌍🌍

Thanks. Makes me feel need to rework my longer running DAX queries.

Pure gold. Thanks

Thanks. I would be interested in seeing a few videos on how to deal with 'time'. What if your granularity is at a second level? How does this affect your model and your measures? Splitting date and time or both? Etc...

Buen trabajo!

Thanks Alberto, another great video. Super interesting to see that you can actually use nested iteration by adding granularity and in your example it was super quick. I have the perfect dataset to test all that tomorrow!

Perfect !!!

Super good

The best lecturer in the world! Just one question (not sure if you do answers) - why Performance Analyser and Dax Studio server timings had 25% difference in speed?

please question: if I said that I understand clearly the video (beside your high quality of teaching of course 🙂) does it mean that I grab some basics about DAX concepts?

nice to see a mechanical keyboard :) What switches are in there?

Hello Alberto, I have some questions: 1- are these RU-vid videos same videos that you offer in the course? 2- will you cover DAX excel solutions in Excel in the course, for an example, selected value and remove filters don’t exist in power pivot, ? Thank you

Can you please create something on dynamic currency conversion in powee bi..we use sap bw data in power bi..and we yet do not have solution for dynamic currency conversion.. please can you create a video on that..will be very usefull

I stuck on nesting 4 level hierarchy and sum/average based on row parameter. Could not find an exit so now turning back to power query to handle this. sorry dax

What about if the 2 two tables that are used are Many to Many? It looks like in this example product/customer are on the 1 side, so sales can be used. In my case I need to look at both table1 and table2. Both table1 and table2 have millions of rows. i.e. SUMX( Table1, --many side SUMX( FILTER( Table2, -- many side Table2[BuyStatus] = 3 && Table2[ClientKey] = Table1[ClientKey] && Table2[DebtorKey] = Table1[DebtorKey] && (Table2[TransPostDate]=(Table1[MonthEnd2]-30)) && (Table2[CloseDate]>'Table1'[MonthEnd2] || ISBLANK(Table2[CloseDate])) ), Table2[Amt] ) )

Why did we use variables inside the SUMX() and not just use the respective columns?