Finding non matching value from other matching value.

[asandor]

Hi,

I want to compare sales reps and their associated zip codes. I have two tables, from different databases and want to create a QC check if the sales rep is properly aligned to the zip code. One database could have the wrong zip attatched to the rep and I want to find that quickly. 

Table1:

ClientPhysician

check for match: SalesRep

match on : zip

Table2:

User Zip Codes Established

check for match: User: Full Name

match on: Zip Code

Summary: Look up zip and SalesRep in Client Physician table, match to User Zip Codes Established table, if sales rep doesnt match, show sales rep and zip.

[Anonymous]

Hi @asandor ,

Need more information.

Can you give me related sample data or pbix file without private sata and your expected result so that I can do a test?

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[ryan_mayu · Accepted solution]

@asandor 

you can try to use lookupvalue

LOOKUPVALUE function (DAX) - DAX | Microsoft Docs

it's better to provide the sample data and expected output

[Greg_Deckler]

@asandor How do you know if the sales rep doesn't match? Is there a sales rep column in Table 2?

[asandor]

Yes, User: Full Name would be the sales rep for table 2.