Forum Discussion

Axiomite's avatar
Axiomite
Resolver II
2 years ago

Related Table / Lookup

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.

Need Help

1 Reply

  • Syk's avatar
    Syk
    Resident Rockstar
    2 years ago

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