Forum Discussion

Atifz's avatar
Atifz
Frequent Visitor
6 years ago

Filtering Table with partial text search from another

Hi,

 

I am quite new to Power BI and i'm trying to filter one table based on a partial text match from another table.

 

Table1: Products

ProductID       Description

1                     Rolex 1995 Men's Watch

2                     Submariner Wall Clock -Rolex

3                     Compact Processor/Blender

4                     Prolex Cordless kettle

 

Table2: AlertTerms

Term

Rolex

Watch

Car

Motorcycle

 

I want to have table 2 as a slicer and when I select Rolex, only products 1 & 2 show up, Not product 4. Is there any way to do this?

 

Any help will be appreciated. Thanks

 

 

 

Need Help

2 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi Atifz ,

     

    You could add below measure into fiter pane, set its value to 1.

    Check =
IF (
    ISERROR (
        FIND ( SELECTEDVALUE ( 'Term'[Term] ), SELECTEDVALUE ( 'Table'[Description] ) )
    ),
    0,
    1
)

     

    • Atifz's avatar
      Atifz
      Frequent Visitor
      6 years ago

      hi v-eachen-msft,

       

      Thanks for this.

       

      It works for some of the terms but there are issues with different cases or space before the search term.

      e.g 1: If the search term is "Rolex", it will not show "rolex" or "ROlex"

      e.g 2: If the term is " rolex", it will not show "rolex".

       

      Is there a way to modify the DAX to include all varients of the search term and not just the exact match? 

       

      Thanks.