Forum Discussion
Solved
Count related table (same ID occurring both tables)
Dear All, i was checking for same issues, since related table questions came up a lot but couldnt find something applicable to mine. So if you could take a look, that would be very helpful! ...
Hi baneworth
It is better to provide some sample data in a format which people can copy, you have distinct values in ID column in both tables? When you said matching, is there a rule or simple they are the same? You only need to count how many IDs, distinct count? In general, you can do something like this
TEST = VAR T1= ADDCOLUMNS(VALUES(Table1[ID]),"CHECK",CONTAINS(VALUES(Table2[ID]),Table2[ID],Table1[ID])) RETURN COUNTROWS(FILTER(T1,[CHECK]=FALSE()))
Hi baneworth ,
Based on your description, do you want to count the mismatched ID when the ID in Table 1 do not match the selected ID?
If I understand correctly, please create the following measure:
Measure = CALCULATE(DISTINCTCOUNT('Table'[ID]),FILTER(ALL('Table'),NOT('Table'[ID] in VALUES('Table (2)'[ID]))))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.