Forum Discussion

morgtd30's avatar
morgtd30
Helper I
4 years ago

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

I've tried using this solution, but it seems to work on an OR basis https://community.powerbi.com/t5/Desktop/Dynamic-filtering-slicing-if-text-contains/td-p/425504   I'd like to achieve the follow...
Tips and Tricks
JeBro's avatar
JeBro
New Member
2 years ago

Hi,

When only Apples is selected, you expect that the table give 3 rows as a result.no result is showing in the table. But in stead only the row with only apples shows up. 

 

 

 

MFelix's avatar
MFelix
Super User
2 years ago

The expected result is 3 rows because we are looking for a word inside a frase not a full match

  • JeBro's avatar
    JeBro
    New Member
    2 years ago

    Hi,

     

    Thanks, but what i ment is my result is 1 instead of the expected 3 with your example.

    • MFelix's avatar
      MFelix
      Super User
      2 years ago

      Hi JeBro 

       

      Are you using the same example as mine or is your different? Are you using the sample file I provided?

       

       

      • JeBro's avatar
        JeBro
        New Member
        2 years ago

        Hi, yes, i used the one provided by you