Selected value is not working as expected when we select slicer options like between, >= and <=

[AnandNamburi]

Hi All,

I have a slicer and I'm displaying year in it.

I want to display the selected value in a card and for that I have written a DAX like below.

Seleged Value of Year = SELECTEDVALUE(Orders[Order Date].[Year])

When I select dropsown or list the selected value is appearing correct in the card but when I select any option like between, greater than equal to or less than or equal to it is displaying blank.

Is there any workaround for this type of requirement.

Thanks,

Anand

[danextian · Accepted solution]

Hi @AnandNamburi ,

SELECTEDVALUE will only show a value if there is one value selected. It's second argument is for displaying something else if there are more than  one values.  That said, selecting a range of numbers or dates means that there are more than one numbers or dates.  I would use either MAX,  MIN, LASTNONBLANK or FIRSTNONBLANK instead.