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 ...
Need Help
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.