Measure based on the selected year from calender table

[mahra-in]

Hi

I need help to create a "Target" measure based on the year selected in visual.

I have a calender table and provided slicer for year selection alone. Based on the selected year my report changes.

Now I want a Target for a particular chart using another table as "30000" if the selected year is "2017" and "20000" if the people choose year as "2018"

Please help.

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

=IF(HASONEVALUE(Calendar[Year]),IF(VALUES(Calendar[Year])=2017,30000,20000),BLANK())

Hope this helps.