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
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

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.