Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Passing Parameters in measures

Hi, Thanks everyone for the comments for my previos posts. I have one more question which I would like to clarify, Is there a way to parameterize values in Measures. For eg: I have created a measu...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Anonymous,

     

    Currently, we cannot use a parameter in a calculated measure directly. To work around this requirement, we could create a query to store parameter value in a dataset, and then use this dataset value in your calculated measure. Please refer to the sample steps below.

    1. Sample parameter.
    2. Create a blank query and edit the query in Advanced Editor
    3. Create a measure in your original table like below.
      Total Sales = CALCULATE(
      SUM('Headcount Data'[May-17]),
      FILTER(Year_Month,Year_Month[Year_Month]=Max(Query2[ParameterDate]))
      )

    Regards,

    Chalrie Liao

     

     

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Anonymous,

 

Currently, we cannot use a parameter in a calculated measure directly. To work around this requirement, we could create a query to store parameter value in a dataset, and then use this dataset value in your calculated measure. Please refer to the sample steps below.

  1. Sample parameter.
  2. Create a blank query and edit the query in Advanced Editor
  3. Create a measure in your original table like below.
    Total Sales = CALCULATE(
    SUM('Headcount Data'[May-17]),
    FILTER(Year_Month,Year_Month[Year_Month]=Max(Query2[ParameterDate]))
    )

Regards,

Chalrie Liao

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I would like to learn more about this approch.

    Do you have an videos or other material you could suggest?