Conditional Formatting by Unrelated Tables

[Nosh10]

Hello!

I need a push solving a problem. 

I have two tables; Table 1: customer ID and email address; Table 2: supplier ID and email address. I would like to show: IF the same email address is in table 1 and table 2, AND have a customer ID and service ID, show email addresses 

Table 1
Customer     ID Email Address
334               [email protected]
                     [email protected]
454               [email protected]
122              [email protected]
                    [email protected]
678              [email protected]
                    [email protected]
                    [email protected]
444              [email protected]
876              [email protected]
444             kkgmail.com

Table 2
Supplier      ID Email Address
1113              [email protected]
1112              [email protected]
                      [email protected]
2345              [email protected]
1111              [email protected]
1000              [email protected]
1100             [email protected]
                     [email protected]
                     [email protected]
5678             [email protected]
2000            kkgmail.com

Table 3 - I'm looking for this result (output) Table 3
[email protected]
[email protected]
[email protected]
[email protected]
kkgmail.com

[Icey · Accepted solution]

Hi @Nosh10 ,

Try this:

Table =
VAR t =
    FILTER (
        CROSSJOIN ( 'Table 1', 'Table 2' ),
        'Table 1'[ID Email Address] = 'Table 2'[ID Email Address]
            && 'Table 1'[Customer] <> BLANK ()
            && 'Table 2'[Supplier] <> BLANK ()
    )
RETURN
    SELECTCOLUMNS ( t, "Email Address", 'Table 1'[ID Email Address] )

Best Regards,

Icey

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