Retrieve SelectedValue when Edit Interaction is OFF

[angelakephart]

Is there anyway to retrieve the selected value from a slicer when a visual has the Edit Interactions Off to that Slicer.  For example, my slicer has a Quarter selected and the value is 8076.  The visual though believes all quarters are selected. I created a measure using Selected Values and have also tried a VAR statement.   The values returned for the SelectedValues are all quarters.

[Telstar]

Hi 

Does anyone have a workaround for this?

I have a suituation where I need to turn the interaction OFF for a visual for a particular slicer BUT then use that selected slicer value in the visual to calculate amounts.

Using SELECTEDVALUE in this situation return an empty result - any ideas much appreciated.

Cheers

Telstar

[v-piga-msft]

Hi @angelakephart,

As I know, you could use SELECTEDVALUE to get the value you selected in Slicer.

For reference, you could have a good look at this article about how to use SELECTEDVALUE function in DAX.

If you still need help, please share some data sample and your desired output so that we can help further investigate on it?

Best Regards,

Cherry

[angelakephart]

Hi,

I have tried the SelectValue, but it retrieves all the values of the filter, not the current selected item only.

[v-piga-msft]

Hi @angelakephart,

It seems that I may misunderstand your scenario.

As I know, the interactions for the visuals is on by default. 

You could control the interaction when you click Edit Interactions, then you could disable the interactions among the visuals. In this scenario, you could not get the selcet value, you only get all values that not be filtered.

Best Regards,

Cherry