Measure to check if values in table A are present in Table B, Connection = DirectQuery not Import

[bipowerbix]

Consider Table A has 2 columns, Name, and Email shown below

Consider Table B are 5 rows and 2 columns Key and Email respectively shown below
 

NOTE: CONNECTION is DirectQuery (NOT IMPORT), I cannot use Calculated Column, can only use Measure. 

How to get this Output:

 

Values in Check can either be YES/NO or 0/1

[FreemanZ · Accepted solution]

hi @bipowerbix 

try to plot table2 columns with a measure like:

measure = 
IF(
    MAX(table2[Email]) IN ALL(table1[Email]),
    1, 0
)

it worked like: