Forum Discussion
Filter table based on another table
Just want to ask something. I have 2 tables in Powe BI. One contains a data set of 13 million rows and the other table contains one columb with the list of values I want to filter in the main table. I...
Can you try this : Table = CALCULATETABLE('TABLE 1',EXCEPT(VALUES('TABLE 1'[ID]),VALUES(TABLE 2 [ID])))
This worked for my particular case. Thank you for posting.
