Question

A Power BI Data Analyst is building a measure that computes the year-over-year growth rate of Total Sales. The current measure references the expression CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date])) three separate times in the DAX formula. The analyst wants to improve readability and ensure the prior-year value is evaluated only once. Which DAX technique should the analyst use?

Accepted Answer

Store the prior-year calculation in a VAR and reference it with RETURN throughout the measure

Answer

Wrap each reference in an additional CALCULATE to force context transition

Answer

Convert the measure into a calculated column so the value is materialized

Answer

Add ALLEXCEPT around each SAMEPERIODLASTYEAR call to cache the result