Forum Discussion
Filter table based on another table
Hi, I would like to filter numbers out based on if they exist in another table. Example given. Table 1 consist ID Text Field Table 2 consist ID I'd like to filter Table...
Anonymous,
Use the DAX below instead.Table = CALCULATETABLE(Table1;EXCEPT(VALUES(Table1[ID]);VALUES(Table2[ID])))
Regards,Lydia
What if I want to keep the values in table 2 and filter out the remaining values from table 1?
I believe you can use INTERSECT instead of EXCEPT