'PowerBI - how to check if an entry with few conditions is present in anther table or not

I have two tables Table A

ID      user      price
1        A          10
2        A          10
1        C          15
3        A          15

Table B

ID       User     price
2         A         20
1         A         10
1         B         15
3         A         15

I need to add a new column to see if a row is present in the other table or not.

Exisits? = IF(CALCULATE(COUNTROWS('Table B'), FILTER('TABLE B', 'TABLE B'[ID] = 'TABLE A'[ID]), FILTER('TABLE B', 'TABLE B'[user] = 'TABLE A'[user]), FILTER('TABLE B', 'TABLE B'[price] = 'TABLE A'[price])) > 0 , "Yes", "No")

But I don't know if there is an issue between the relationships and I don't know why a relationship even matters for such a DAX formula because I have so many linking between the tables where it is not exactly a relationship but I create a relationship just for the sake of getting correct results for DAX. But all the results for the above DAX is "No". Why? Obviously, there is are entries in Table B that are in Table A.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source