Forum Discussion

mtrevisiol's avatar
mtrevisiol
Icon for Helper V rankHelper V
5 years ago

SELECTEDVALUE does not work

Hi everyone.  I've got a calendar table with a hierarchy of dates and a slicer withe the years in the report.  I created a measure that should return the selected year, using   selected year = S...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

mtrevisiol 

Hope you have a Year column in the Calendar table?

Try this: 
selected year = SELECTEDVALUE(Calendar[Year], 123)

 

  • mtrevisiol's avatar
    mtrevisiol
    Icon for Helper V rankHelper V
    5 years ago

    I've just tried, but still doesn't work...