Multi-Select filtering column checking if it contains multiple pieces of text

Hi morgtd30 ,

 

I made a similar approach to this on this post:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Find-Words-on-sentence-from-another-selected-sentence/m-p/1602658#M658

 

Making some small adjustment I was abble to reach the following measure:

Find Word Formula_V2 = 
// Character that split phrase into words
VAR SplitByCharacter = " " 

// Temporary table that splits selected phrase into words
VAR Words_table =
   
        ADDCOLUMNS (
            GENERATE (
                SELECTCOLUMNS (
                    ALLSELECTED (Slicer[Slicer] ),
                    "Find_Text", Slicer[Slicer]
                ),
                VAR TokenCount =
                    PATHLENGTH ( SUBSTITUTE ( [Find_Text], SplitByCharacter, "|" ) )
                RETURN
                    GENERATESERIES ( 1, TokenCount )
            ),
            "Word", PATHITEM ( SUBSTITUTE ( [Find_Text], SplitByCharacter, "|" ), [Value] )
        )
RETURN
    IF (
// Function that returns the sum of the values of the words found in the sentance
        SUMX (
            Words_table,
            FIND (
// additonal spaces in the beginning and ending of each word allows to find the exact match, also removed the last "." so that would be specific words
                 UPPER ( [Word] ) & " ",
                 UPPER (  SELECTEDVALUE ( 'Table'[Text] ) ) &" ",
                ,
                0
            )
        ) > 0,
        1,
        BLANK ()
    )

 

See result below and in attach PBIX file:

 

If you want you can set the measure on the visualization filter pane and set it to non blank values.

 

Hi morgtd30 

(1)Create a table with selection “Apples”,” Oranges”,” Grapes”,” Bananas”.

(2)Add a slicer with [Slicer] .And then create a measure to return the string of select value .

Measure 2 = CALCULATE(CONCATENATEX(VALUES(Slicer[Slicer]),Slicer[Slicer],"; "))

(3)Create a measure to judge whether the Measure 2 in the column [Text] .If yes ,return 1 , otherwise return 0 .

CONTAINSSTRING = IF(CONTAINSSTRING(SELECTEDVALUE('Table'[Text]),Slicer[Measure 2]),1,0)

(4)Put the CONTAINSSTRING measure in visual filter and set CONTAINSSTRING is equal to 1 .The final result is as shown :

I have attached my pbix file , you can refer to it .

 

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.