Forum Discussion

cartman21's avatar
cartman21
Helper I
9 years ago

Creating a filtered table via a contains function

Hello,   I have an urgent question for which I could really use some help.   Basically, I have a huge amount of data pulling in from an external resource, which is great.   I have say, 3000 com...
Need Help
cartman21's avatar
cartman21
Helper I
9 years ago

Hello, thanks for taking the time to respond!

 

The problem is that the list is of KEY investors is like this:

 

 

But the data i am being fed has stuff like this:

 

 

So the method you provide sadly does not work due to this reason.

 

Any ideas?

 

 

MFelix's avatar
MFelix
Super User
9 years ago

Hi cartman21,

 

Not abble to see this in the afternoon will try to get back to you tomorrow morning.

 

regards

MFelix

  • cartman21's avatar
    cartman21
    Helper I
    9 years ago

    hi MFelix any help would be much appreciated, thanks!

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      9 years ago

      cartman21

       

      Hi, a partial solution.  

       

      This works only with 1 selection in slicer of investors.

       

      A measure:

       

      MatchInvestor =
IF (
    HASONEVALUE ( Investors[Investor] ) && HASONEVALUE ( Table1[Investor] ),
    IF (
        FIND (
            SELECTEDVALUE ( Investors[Investor] ),
            VALUES ( Table1[Investor] ),
            1,
            0
        )
            <> 0,
        1,
        0
    )
)

      And add in the Visual level filter of your table visual and select only when measure is 1.

       

      Regards

       

      Victor

      Lima - Peru