SELECTEDVALUE does not work

[mtrevisiol]

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 = SELECTEDVALUE(Calendar[Date].[Year], 123)

but I always get the alternative result (123), even if the year is selected. Do you know what the problem could be? Thank you.

[v-jingzhang]

Hi @mtrevisiol 

Did you select multiple year values in the slicer? The SELECTEDVALUE only returns a single value. When multiple values are selected or none value is selected, it will return the alternative value. When you select a single year value, it works well.

I created a sample file, see if there is any difference from yours.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[Fowmy]

@mtrevisiol 

Hope you have a Year column in the Calendar table?

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

[mtrevisiol]

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