DAX Optimisation

Uhrond — Wed, 29 May 2024 10:29:45 GMT

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

Re: DAX Optimisation

Kaviraj11 — Wed, 29 May 2024 13:53:18 GMT

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

topic Re: DAX Optimisation in DAX Commands and Tips

DAX Optimisation

Re: DAX Optimisation