Find non match ID between 2 unrelated tables

[Dimitris_Kats]

Hello dear members 

I have 2 facts tables (unrelated). Both of them are having an ID column. I want to find all the id's from the one table that are not included in the other table.

How can achieve that??

Thank you very much 

[tamerj1 · Accepted solution]

Hi @Dimitris_Kats 
You can create a calculated table as follows

=
EXCEPT ( VALUES ( DirectQuery[EmpID] ), VALUES ( Excel[EmpID] ) )

[Dimitris_Kats]

Thank you very much @tamerj1

The calculated table solved my problem!

@SpartaBI thank you very much for your time!! 

[SpartaBI]

@Dimitris_Kats my pleasure. 
@tamerj1 was faster this time 😜

@Dimitris_Kats Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543

[SpartaBI]

@Dimitris_Kats do you want to show me on teams / zoom?

[Dimitris_Kats]

@SpartaBI  hello

Thank you very much for the file. 

The lookupvalue is not accepted at the calculated column. I must say that the one table is from a direct query and the other from an excel. I don't know if that's playing a role.

Any other measures I could try??

Thank you very much again for your help 

[SpartaBI]

@Dimitris_Kats 
This is an sample solution file with calculate column:
Find non match ID between 2 unrelated tables 2022-08-05.pbix

Showcase Report – Contoso By SpartaBI