Forum Discussion
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...
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.
- Sample parameter.
- Create a blank query and edit the query in Advanced Editor
- 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
- Sample parameter.
ara0530
Advocate I
Advocate INone of these are useful. In all these solutions, you are 'hardcoding' the value. How can we allow the user to change the parameter value in the report (i.e. like a slicer)?