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

    Thanks Ritaf1983 

    This looks good and promising. However, there is a challenge, the list of keywords is huge (hundreds of books), and each row has large number of keywords (all nouns in a book).  So making a duplicate column, and then normalizing that entire table would result in huge list I believe.

    • Ritaf1983's avatar
      Ritaf1983
      Super User
      3 years ago

      vishal0soni Unfortunately I don't think we have another kind of solution, that's necessary to make the relationship...same logic as lookup.

      If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

      • vishal0soni's avatar
        vishal0soni
        Advocate III
        3 years ago

        Can we make use of string functions like FIND or SEARCH dynamically to obtain the desired results on the fly?