Filter a table based on string values in another table

Question

Hi everybody,Suppose I have the following table, "Table 1", that has a Serial Code column containing a string of text. I am trying to filter this table based on whether or not the Serial Code contains particular substrings. The substrings I want to check for are listed in another table, "Table 2".&nbsp;Table 1&nbsp;RowSerial Code1ABC***********2*****************3***DEF********4*******XYZ****5***ABC***DEF***6****************7****************8XYZ***ABC*********9******************10DEF*******XYZ*****&nbsp;Table 2SubstringsABCDEFXYZ&nbsp;Basically the logic is: For each row in Table 1, check if the Serial Code contains any of the Substrings listed in Table 2. If yes, keep the rows. If no, filter out the rows. So the resulting table will be as below.&nbsp;Result&nbsp;RowSerial Code1ABC***********3***DEF********4*******XYZ****5***ABC***DEF***8XYZ***ABC*********10DEF*******XYZ*****&nbsp;Is this possible with DAX?&nbsp;Thank you for reading!

amitchandak · Accepted Answer

Anonymous , You can try a new column like
&nbsp;
New column = var _1 =countx( filter(Table2, search(Table2[Substrings], Table[Serial Code],,0)&gt; 0),Table2[Substrings])return if(not(isblank(_1)),1, blank())

Forum Discussion

Filter a table based on string values in another table

2 Replies

Related content

Read Notebook cell string from another notebook

String substraction from another string

Slicer Filtering Another slicer

Filter depending on another filter

String and Sub-String Filter

Table 1
Row	Serial Code
1	ABC***********
2	*****************
3	*DEF******
4	*****XYZ**
5	*ABCDEF**
6	****************
7	****************
8	XYZ*ABC*******
9	******************
10	DEF*****XYZ***

Result
Row	Serial Code
1	ABC***********
3	*DEF******
4	*****XYZ**
5	*ABCDEF**
8	XYZ*ABC*******
10	DEF*****XYZ***