Forum Discussion

abhiram342's avatar
abhiram342
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago
Solved

Evaluate DAX Measures Dynamically

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 sq...
DAX
  • tamerj1's avatar
    tamerj1
    4 years ago

    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"
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

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"
)
abhiram342's avatar
abhiram342
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

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

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

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