topic Get the selected value from Slicer but after disabling Interaction between slier and table in DAX Commands and Tips

Get the selected value from Slicer but after disabling Interaction between slier and table

Anonymous — Wed, 14 Apr 2021 11:33:20 GMT

Hi I would like to find a way to get the selected value from the slicer but after disabling the interaction between slicer and the visual.

I have a report to show one visual with all sales and other table with sales related to the seleted date in the date slicer.

I have disabled the Interaction between date slicer and the all sales table, but now I need to get that selected date value to use in one of the measure in this table. Is there any way to achive this ?

Just becasue there is no interaction I am getting blank value.

Any experts, kindkly please help 🙂

Kind Regards

Selva

Re: Get the selected value from Slicer but after disabling Interaction between slier and table

amitchandak — Wed, 14 Apr 2021 13:33:29 GMT

Anonymous , if you stop interaction you will not get the value to be used in the formula

You can use independent date table , refer - https://www.youtube.com/watch?v=44fGGmg9fHI

Re: Get the selected value from Slicer but after disabling Interaction between slier and table

Anonymous — Wed, 14 Apr 2021 13:36:12 GMT

Thanks Amit 🙂