Forum Discussion
DistinctCount for matching values on two columns
Hi, I am strugling with the DAX formula (new to DAX..) for counting how many rows in one table match the values in another one. Here the example: Table 1 = ID, quantity Table 2 = ID, quantit...
If I understand your question correctly, you can use this measure to calculate the amount of matches between table 1 & table 2:
countMatches = CALCULATE(COUNT(tbl1[ID]) , FILTER(tbl1,LOOKUPVALUE(tbl2[ID],tbl2[ID], tbl1[ID])))