Lookup with logic on multiple rows

MAruna 
Please try

=
MAXX (
    FILTER (
        UNION (
            SELECTCOLUMNS ( Table2, "@ID", Table2[Empid], "@Region", Table2[Region] ),
            SELECTCOLUMNS ( Table2, "@ID", Table2[Canid], "@Region", Table2[Region] )
        ),
        [@ID] = Table1[id]
            && [@ID] <> BLANK ()
    ),
    [@Region]
)