Relating data from 3 tables

Hi akathuri01 

Based on your needs, I have created the following table.

You can use the following Measure to get the matching status of the two tables:

MEASURE = 
IF (
    ISBLANK ( SELECTEDVALUE ( Table1[Name - Table -1] ) )
        || ISBLANK ( SELECTEDVALUE ( Table1[Ticker -table 1] ) )
        || ISBLANK ( SELECTEDVALUE ( Table2[Name - Table -2] ) )
        || ISBLANK ( SELECTEDVALUE ( Table2[Ticker -table 2] ) ),
    "Removed from group",
    IF (
        SELECTEDVALUE ( Table1[Ticker -table 1] )
            = SELECTEDVALUE ( Table2[Ticker -table 2] )
            && SELECTEDVALUE ( Table1[Name - Table -1] )
                = SELECTEDVALUE ( Table2[Name - Table -2] ),
        "Match",
        "Name changed"
    )
)

Create a new table, and then make the following settings in the filter:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.