How to filter results for one table by column in another table?

[rsderby68]

I have a table that contains a customer_id column which a few thousand entries.  I have another table that lists a customer_id column of "bad" ID's that I want to filter OUT OF the first table.  The end result would be the first table minus any rows of the "bad" customer_id listed in the second table.  Help?  

[Nankaina · Accepted solution]

There are likely several ways to do this. I would approach it by adding a calculated column to your first table which tests whether the customer_id is within the second table's list:

Good IDs = IF(Table1[customer_id] in VALUES(Table2[bad_ids]), True, False)

 You can edit the True and False outputs to be anything you'd like, and slice by "True" to see only those customers without bad IDs.

[rsderby68 · Accepted solution]

I actually got it to work using a version of: 

FILTER ( Table1, NOT Table1[Id] IN DISTINCT ( Table2[Id] ) )

It's amazing how much you can learn at Power BI when you are dealing with a crappy data source!  🙂  Thanks All! 

[Nankaina · Accepted solution]

There are likely several ways to do this. I would approach it by adding a calculated column to your first table which tests whether the customer_id is within the second table's list:

Good IDs = IF(Table1[customer_id] in VALUES(Table2[bad_ids]), True, False)

 You can edit the True and False outputs to be anything you'd like, and slice by "True" to see only those customers without bad IDs.