Power Query - Filter Table Based on Distinct Conditions from List

[danhendo888]

https://www.youtube.com/watch?v=fRd6wYkfDUQ

In this video, Mike uses a list to extract rows from the Start table that DO NOT include anything from the list.

Is the opposite possible?
If it's in the list, then extract rows from the Start table that contain it.

E.g.
Suppose the list only has XYZ (Product Name)

Then from the Start table, output would be rows that contain XYZ (Product Name)

i.e. Output:
https://imgur.com/a/mMZjpDH

 

[sandy666]

simply add condition <> true like:

[SIZE=1]Table.SelectRows(Source, each List.IsEmpty(List.Intersect({Text.Split([Product_Name]," "),NotCriteriaSolution})) [B][COLOR="#0000FF"]<> true[/COLOR][/B])[/SIZE]