How to filter unrelated items between two related tables?

[igaddy79]

Hello,

I've been searching all over the forums and couldn't find a clear answer, so I decided to post my question.

How to filter unrelated items between two related tables?

I have two tables, which I have created the one to one relationship by email.

My issue is identifying and showing the emails that don't match from one of the two tables. 

Heres my idea of what the expression may say:

subtract(table1 [emails]) - (table2 [emails]) = all unmatched emails

I need to be able to display the data. Thanks

[amitchandak]

Please try except

https://docs.microsoft.com/en-us/dax/except-function-dax

[igaddy79]

Hi, I tried EXCEPT, but no luck. The error I receive stated: unable to use EXCEPT due to both tables not having the same number of columns. 

I have two tables that I have established relationships for in BI one to one (email). After identifying the matching emails. I would like to view the remaining email minus the match emails from both tables in a separate list/view.

Thanks, Again

[Anonymous]

Hi,

Making sure I understand the desire....you have 2 tables, for which you've created a relationship between them via an email column.  Your desire is to output the results of that effort in which the cases where there are emails that do not exist in table 2 but are in table 1, and likewise the ones that don't exist in table 2 but do in table 1?

Perhaps an example data would help drive your intent?