Understanding eager vs. strict evaluation in DAX

Learn the differences between eager evaluation and strict evaluation in DAX, in order to choose the best evaluation type for your data models.

[pilarbaldominos]

Ayyy Alberto! You have saved me again... My If formula was not performing at all and now it is working much much better! Thanks again!!

[DataHacker]

Wow! That gave me a big insight into how calculations are done. Thank you very much!

[beginho]

Thank You, Alberto.
You make complex concepts easier to understand with good examples! ☺

[charlpotgieter]

Thanks for another excellent video! I must confess though that I do struggle a bit with the usage of “strict” and “eager” terminology here compared to the standard usage of these terms when used to describe programming languages. I almost feel as if we need a different set of terms to describe these optimisation techniques.

[mau_lopez]

Great video, very informative and a very nice explanation. Thanks a lot Mr Ferrari!

[MrHamzaAbi]

Just amazing ! Super clean Dax coding ❤️ thank you ! 🙏🏻

[johansantacruz]

Is there a way to enforce Strict way using variables? Thanks in advance.

[stevenknight]

Certainly another tool added to the kit bag, thanks once again.

[narendrababu]

Sir how to seperate even row number records and odd row number records from a table in power bi.

[nishantkumar]

Thank you very much for such a clean, detailed and easy to understand explanation of each of the concepts.
Could you please bring a video about automating FIFO methodology using DAX.Thans once again.

[kamalverma]

Hi Alberto, once again an amazing video, I have couple of questions not related to this topic but very important. you may guide me to any article that you would have published, I couldn't find one. First Q, can iterators (e.g sumx) function can be used to Direct query mode. If yes, then is it advised to use ? Secondly, once I schedule auto refresh(dataset) in power bi service, does the report/dashboard/apps also get updated or I have to click on refresh button to get them updated? Look forward to hearing from you soon.

[dariuszspiewak]

I have always thought that in functional languages variables are evaluated lazily, that is only when they are actually needed. This video shows that this is not the case in DAX, which is a functional language as well. Interesting... But then, what happens when we define a variable in our measure and then will never use it subsequently? Will it also get evaluated regardless?

[diegomex]

awesome, this video need a googol of like