Forum Discussion
Solved
Variable in power BI
Hi All, \
I need a variable in DAX .
When i select the year filter in list box then selected year value should be assigned to the variable in DAX.
Like I have Year list box :- 2018 2017 2016 2015
When I select year =2018 then
calculate(Sum(amount),year=Variable)
where Variable value should be 2018 I selected 2018.
Please guide me.
Thanks.
Narender
Narender Please try this..
TotalAmount = VAR _year = SELECTEDVALUE(SumSlicer[Year]) RETURN CALCULATE(SUM(SumSlicer[Amount]),SumSlicer[Year] = _year )
1 Reply
Narender Please try this..
TotalAmount = VAR _year = SELECTEDVALUE(SumSlicer[Year]) RETURN CALCULATE(SUM(SumSlicer[Amount]),SumSlicer[Year] = _year )