Find a selected word in a sentence in another table

[Anonymous]

I have a table with a word listing and product,  I have survey free text answers in 4 separate tables based on product and survey time so I created a word frequency based on the the # of times a word is used in the sentences and I would like for the user to select that word from a visual and then see all the responses that contain that word in a new table visual.  The tables have no joins.  Is this possible?  I tried to play with selected values and contain and nothing worked.

[V-pazhen-msft · Accepted solution]

@Anonymous 

I created a short example, please check the pbix for detail.

Keyword = IF(SEARCH(SELECTEDVALUE('Table (2)'[Key words]),MIN('Table'[Sentence]),,0)>0,SELECTEDVALUE('Table (2)'[Key words]))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[VijayP]

@Anonymous 

Using TREATAS Function and CONTAINSSTRING Funciton you can achieve this. Try that, mean time if any sample data can help give more concrete answer