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...
amitchandak
Super User
Super Userallejot , Create a new column in Table 2
new column =countx(filter(table1,table1[ID] =table2[ID]),table[ID])
any value means that is present in table 1