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
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