DAX Optimisation

[Uhrond]

Hi,

I have multiple measure that start with the same variable :

VAR TO_CALCULATE = IF(AND(COUNTROWS(INDIC) = 1, MAX(INDIC[TYPE_LIGNE]) = "INDIC") , TRUE() , FALSE())

 Is it faster to create one separate measure "TO_CALCULATE" with this formula and use this new measure in my multiple other measure ?

Thank you

[Kaviraj11 · Accepted solution]

In terms of performance, using a variable is generally faster because it’s calculated once within the context of the measure where it’s used.

If the logic is complex and used in many different measures, defining it once as a variable and then using that variable within the same measure can be more efficient than referencing a separate measure multiple times.

Hence, Variables are better in performance. 

DAX Variables: Better Readability, Consistency, and Performance in Power BI Calculations - RADACAD