topic Re: Evaluate DAX Measures Dynamically in DAX Commands and Tips

Evaluate DAX Measures Dynamically

abhiram342 — Tue, 24 May 2022 04:14:58 GMT

Hi Team,

I want to run below dax code for different measures. Currenlty, measure value is repeating for all rows. Can you please tell how to evaluate below measure dynamically (similar to dynamic sql)

EVALUATE
VAR MeasureName = 'Sales'[Total Sales]
VAR Sales =
SELECTCOLUMNS(
SUMMARIZECOLUMNS
(
'Product'[Product Name],
"Total Sales", MeasureName
),
"DimensionValue",'Product'[Product Name] ,
"MeasureValue",[Total Sales],
"MeasureName","Total Sales",
"DimensionName", "Product Name")
RETURN
Sales

Thanks,

Abhiram

Thanks,

Abhiram

Re: Evaluate DAX Measures Dynamically

tamerj1 — Tue, 24 May 2022 04:40:06 GMT

Hi abhiram342
Don't store the measure in a variable

EVALUATE SELECTCOLUMNS ( SUMMARIZECOLUMNS ( 'Product'[Product Name], "Total Sales", 'Sales'[Total Sales] ), "DimensionValue", 'Product'[Product Name], "MeasureValue", [Total Sales], "MeasureName", "Total Sales", "DimensionName", "Product Name" )

Re: Evaluate DAX Measures Dynamically

abhiram342 — Tue, 24 May 2022 04:46:44 GMT

Hi tamerj1 - thank you ! WithOut variable it works as expected but I was looking how to excute using variable. I want to pass variable name as parameters in power bi report so that I can reuse Dax code

Thanks,

Abhiram

Re: Evaluate DAX Measures Dynamically

tamerj1 — Tue, 24 May 2022 04:55:17 GMT

Hi abhiram342
Variables are evaluated only once. This cannot be achieved at least not this way.