Remove multiple lines on the table based on a blacklist table

[HelpNeeded21]

Hello everyone, I'm new to Power BI, so I hope you guys can help me. I have a big table, and one of the fields contains information that I need to remove (not all the lines), on the other hand, I have a "blacklist" table, so I want to use the blacklist table to filter the main table and remove all the lines which match the blacklist.  How can I get that? Thanks in advance for your support

[Greg_Deckler · Accepted solution]

@HelpNeeded21 - Welcome. To do that you will want to use a Merge query and use a Left or Right Anti join. You could also do it in DAX using EXCEPT function.

Also, since I see you are a New Member, just for reference:

• https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
• https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490