Forum Discussion

smpa01's avatar
smpa01
Community Champion
3 years ago
Solved

DAX Left Anti Inactive Relationship

I have two tables called 'left' and 'right'   | left.colA | left.Val | |-----------|----------| | 1 | A | | 2 | B | | 4 | D | | 5 | E ...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    3 years ago

    Hi, smpa01 , you always come up with tricky and interesting questiongs.

     

    In theory, the expected result can be achieved this way,

     

    But from perspective of modeling, such an anti-join is a typical violation of reference integrity

     

CNENFRNL's avatar
CNENFRNL
Community Champion
3 years ago

Hi, smpa01 , you always come up with tricky and interesting questiongs.

 

In theory, the expected result can be achieved this way,

 

But from perspective of modeling, such an anti-join is a typical violation of reference integrity