Forum Discussion
Search within a text column if one or multiple KeyWords are a match
Here is one approach to consider. I made a disconnected table with your Detail values and used the measure below in a table visual. The row that does not include one of the selected values is automatically filtered out.
ContainsSlicerValue = VAR slicerlist = VALUES ( SlicerValues[Detail] ) VAR thisitemdesc = MAX ( T3[Item Description] ) VAR filtered = FILTER ( slicerlist, CONTAINSSTRING ( thisitemdesc, SlicerValues[Detail] ) ) RETURN IF ( COUNTROWS ( filtered ) > 0, "Y" )Pat
Solution SageHere is one approach to consider. I made a disconnected table with your Detail values and used the measure below in a table visual. The row that does not include one of the selected values is automatically filtered out.
ContainsSlicerValue =
VAR slicerlist =
VALUES ( SlicerValues[Detail] )
VAR thisitemdesc =
MAX ( T3[Item Description] )
VAR filtered =
FILTER ( slicerlist, CONTAINSSTRING ( thisitemdesc, SlicerValues[Detail] ) )
RETURN
IF ( COUNTROWS ( filtered ) > 0, "Y" )
Pat
Hi Pat!
Thank you so much for your help, it seems you are getting exactly what I need.
I tried to follow your instructions, but, the moment I select something on filter, nothing happens on the table.
Did you somehow connected both tables?
I just figured it out where my mistake was! thank you so much for your help! it helped me a lot!
Thank you!
