Forum Discussion

PamelaAG's avatar
PamelaAG
Frequent Visitor
3 years ago
Solved

Search within a text column if one or multiple KeyWords are a match

Hi all, I would like to know if there is a way to create a new column that looks for different keyworkds and create a list of all possible results.  For example, based on the following table    ...
Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    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

     

     

ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

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

 

 

PamelaAG's avatar
PamelaAG
Frequent Visitor
3 years ago

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?