Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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"
)
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"
)
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
Hi @abhiram342
Variables are evaluated only once. This cannot be achieved at least not this way.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |