Forum Discussion

Tinus1905's avatar
Tinus1905
Resolver I
2 years ago

Filter slicer with IF function

Hello,    I want to use my slicer and when I select the value "Cars" then the output in my card has to be "Cars measure", when I select the value "Music" then the output in my card has to be "Music...
Need Help
AilleryO's avatar
AilleryO
Memorable Member
2 years ago

I do not know exactly what you need  (single or multiple value ?), but you can try :

Filter = IF( SELECTEDVALUE('Sample Table'[Value3]) = "Cars", [Cars measure], [Music measure])

 Works with single values, but shloud be your case, isn't it ?

Let us know