Forum Discussion
mahra-in
Helper II
Helper IIMeasure based on the selected year from calender table
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.
Hi,
Try this measure
=IF(HASONEVALUE(Calendar[Year]),IF(VALUES(Calendar[Year])=2017,30000,20000),BLANK())
Hope this helps.
1 Reply
- Ashish_Mathur
Super User
Hi,
Try this measure
=IF(HASONEVALUE(Calendar[Year]),IF(VALUES(Calendar[Year])=2017,30000,20000),BLANK())
Hope this helps.