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,

 

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

    • MFelix's avatar
      MFelix
      Super User
      2 years ago

      Hi JeBro ,

       

      Have you made any change to the measures or model? I just downloaded the file and all works correctly:

       

      • DebLee's avatar
        DebLee
        New Member
        2 years ago

        Hi MFelix! I stumbled across your post while looking for a measure to solve an issue I'm facing in PowerBI. 

        From your last message, do you have a measure that when Apples and Oranges are selected from the slicer, only row 01/02/2018 appears, and when Apples, Oranges and Grapes are selected fromt he slicer, only row 03/04/2018 appears. 

        But when only Apples are selected on the slicer, then all three rows will appear. 

        Thanks in advance!