How to format a Dynamic Contains String to Exclude

[Housden996]

Hi

My client wants to exclude emails from a list based on key phrases being stored in a sharepoint list, is this possible. 
I am thinking something along the lines of this but there isnt a way to join the two tables are the domain for the emails are all unique:

Exclude = IF(CONTAINSSTRING('Clients and Emails'[Contact Email], 'Exclude'[Exclude]),1,0)

Thanks in advance!

[Tahreem24]

@Housden996 , It would be great if you can share the sample input data along with expected output in order to understand your query.

[Housden996]

Thanks for your response. 

So the intial data table would look along the lines of:

Then there would be another data source the client has access too where they can add records along the line of:

I would then need some dax to exclude any of the emails which contain said phrases within the table above to return a table such as bellow:

[Tahreem24 · Accepted solution]

@Housden996 Thanks for sharing this sample input data. So, here I took the sample for  EmailTable and ExcludeTable like this:

Step 1: Go to Transform Data option, Select EmailTable, then select "Email" column and right click and choose "Duplicate Column"

Step 2: Then right click on this above duplicate column and follow the below step for splitting

Step 3: Remove the extra column after splitting

Step 4: Click on Merge as New query option

Step 5: Do the below setting

Step 6: Then save and close.
Step 7: On Table visua;, take ID and email from this Merge1 table

[Housden996]

Thank you this is the same solution I have come up with as well which will work for most instances.

[Tahreem24]

@Housden996 , You're welcome!