Measure with variable filter (year)

[viferenc]

Dear All,

I would need your help as I do not manage by myself to solve my problem

I have simple measure 

Volume Growth rate = ((calculate((calculate(sum('Tint Sales'[Volume]);'Tint Sales'[CATEGORY_ID] >= 1;'Tint Sales'[CATEGORY_ID]<= 4;'Year'[Year]=2017)+calculate(sum('Tint Sales'[Volume]);'Tint Sales'[CATEGORY_ID] = 6));'Year'[Year]=2017))/(calculate((calculate(sum('Tint Sales'[Volume]);'Tint Sales'[CATEGORY_ID] >= 1;'Tint Sales'[CATEGORY_ID]<= 4;'Year'[Year]=2016)+calculate(sum('Tint Sales'[Volume]);'Tint Sales'[CATEGORY_ID] = 6));'Year'[Year]=2016)))-1

In this measure the years are fix. But I would like to change it to variable, if I would choose the in the year filter 2017 in the first part of the measure should be stay 2017 and in the second part 2016. The same if I choose in the filter 2016, in the first part should stay 2016 and in the second part should stay 2015. 

I would really appreciate if somebody could help me

Thank you in advance

Feri

[Vvelarde · Accepted solution]

@viferenc

Assuming that you are using a slicer with year column

2 measures

Year=Values(Year[Year])

Year-1=Values(Year[Year])-1

or you can replace it in your measure 

[viferenc]

Thank you very much for the quick help. It works properly. Best regards Feri

[v-huizhn-msft]

Hi @viferenc,

I am very gald you have resloved your issue, please mark the right reply as answer. So that other people having similar problems will find workaround easily. Thanks for understanding.

Best Regards,
Angelia