Filtering Table with partial text search from another

[Atifz]

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

[v-eachen-msft]

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]

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.