'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 |
|---|
