IF, SWITCH And The Effect Of DAX Variables On Strict/Eager Evaluation
Chris Webb BI
NOVEMBER 26, 2023
A lot of DAX performance problems relate to the use of strict and eager evaluation with the IF or SWITCH functions. It’s an incredibly complex, “it depends”, black-box type of topic and naturally Marco and Alberto have a great article on it here. Rather than describe any general rules – which would be pretty much impossible – in this blog post I want to show a specific scenario that illustrates how the use of DAX variables can influence whether strict or eager evalu
250 
Let's personalize your content