Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Use the DAX below instead.

    Table = CALCULATETABLE(Table1;EXCEPT(VALUES(Table1[ID]);VALUES(Table2[ID])))



    Regards,

    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks alot! Works like a charm!