Indirect slicer

[Anonymous]

Hello

Is it possible to use a slicer with specific value/range options to filter a field in another table via a function?

E.g. a slicer has two options: 0 and 1.

If 0 is selected then e.g. Col1 of a table is filtered by >4.

If 1 is selected then Col1 of a table is filtered by <4. 

Thanks!

[Anonymous · Accepted solution]

Hi @Anonymous 

You may use SELECTEDVALUE('Table'[Column]) to get the value of the selection in slicer and store it as a Variable. 

Now you can use this variable for calculation logic derivation.