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

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