Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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 )
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.
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |