Forum Discussion

vishal0soni's avatar
vishal0soni
Advocate III
3 years ago
Solved

Filter / Display rows based on substring present within a slicer

I have a list of items (Apple, Bat, Cherry, Dog, and Elephant). One or more of these items may or may not appear in the list of multiple comma-separated keywords (Apple, Cherry, Elephant). What i n...
Need Help
  • vishal0soni's avatar
    vishal0soni
    3 years ago

    I think I got the easiest way of doing this just by using SEARCH function.

    We can write this measure:

    Exists = SEARCH(

        SELECTEDVALUE('Products'[Product]),

        SELECTEDVALUE(Solution_Products[SolutionProducts]),

        ,-1)
     
    And then use this as a filter criterion for displaying the values. 
    It works perfectly fine as desired. 
     
     
  • vishal0soni's avatar
    vishal0soni
    3 years ago

    Ritaf1983 I got it. Used SEARCH function in a measure, and then used that in the filter. 

vishal0soni's avatar
vishal0soni
Advocate III
3 years ago

I think I got the easiest way of doing this just by using SEARCH function.

We can write this measure:

Exists = SEARCH(

    SELECTEDVALUE('Products'[Product]),

    SELECTEDVALUE(Solution_Products[SolutionProducts]),

    ,-1)
 
And then use this as a filter criterion for displaying the values. 
It works perfectly fine as desired.