Remove rows which contain data in another Table

Hey Anonymous ,

I'm wondering why you don't want to use a merge?

Using Power Query the left-anti join is designed for exactly this use case.

If the data will be refreshed, the Power BI dataset, will only contain the remaining rows.

The next screenshot shows the merge dialog. 

After the merge (Left Anti) my simple fact table will look like this:

Then, of course, you can remove the column that contains the table, and it's done.

Hopefully, this provides what you are looking for.

Regards,

Tom

New Table =
FILTER ( TableA, NOT ( TableA[ID] IN VALUES ( TableB[ID] ) ) )

Link to the sample pbix file