Related Table / Lookup

[Axiomite]

Hi there, 

I have the following table

Dax Measure

Match /No Match = 
IF(
    
        Table1[Acc] = RELATED('Table2'[Acc]),
       
    
    "Match",
    "No_Match"
)

I would expect 1 Match, however, I get a value returning both rows as "Match".
The 2 tables are connected Many to one. 

What am I missing? 

Kind Regards.

[Syk]

'Table1'[Acc] 1 has 2 matches since each of your 'Table2'[Acc] values are both 1.
'Table1'[Acc] 0 has 0 matches.