If condition in two tables

Hi tgo,

What does the second table look like? If you'd like to filter the IDs, I would suggest you do it like below.

1. Create a new table. 

New Table =
DISTINCT (
    UNION ( VALUES ( 'table 1'[ID from] ), VALUES ( 'table 1'[ID to] ) )
)

2. Create a measure.

Measure =
IF (
    MIN ( 'table 1'[ID from] ) = SELECTEDVALUE ( 'New Table'[ID from] )
        || MIN ( 'table 1'[ID to] ) = SELECTEDVALUE ( 'New Table'[ID from] ),
    1,
    BLANK ()
)

Finally, you can select one time to filter the two columns.

Best Regards,

Dale