Forum Discussion

Uhrond's avatar
Uhrond
Frequent Visitor
2 years ago
Solved

DAX Optimisation

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...
DAX Optimization
  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

    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

Kaviraj11's avatar
Kaviraj11
Icon for Solution Sage rankSolution Sage
2 years ago

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