Link Table for Customer get error msg

[admin11]

Hi All

My AR table customer table unable to link with my SOURCE table. 

i using this expression to link :-

Customer = DISTINCT(UNION(ALL(AR[Customer/Vendor Code]), all(SALES[CUST_ID])) )

I get below error msg :-

Column '' in Table '' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

 Can some one advise me how to clear the error msg ?

Sample PBI file :-

https://www.dropbox.com/s/8ggmos7cydb9wzu/PBT_V2021_115%20SOLVE%20ar%20CUSTOMER%20NOT%20LINK.pbix?dl...

Paul

[VahidDM]

Hi @admin11 

Try this:

Customer = DISTINCT(UNION(values(AR[Customer/Vendor Code]), values(SALES[CUST_ID])) )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

New Year Power BI eCard:

https://community.powerbi.com/t5/Data-Stories-Gallery/Happy-New-Year/td-p/2266398

[admin11]

@VahidDM 

Thank you for  sharing.

I have try your expression , it still have error.

[Anonymous · Accepted solution]

Hi @admin11 ,

The reason for the error is that this column contains null values.

Result after filtering out blank values

Customer = DISTINCT(UNION(ALL(AR[Customer/Vendor Code]), filter(all(SALES[CUST_ID]),[CUST_ID]<>BLANK())) )

Best Regards,

Stephen Tao

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

[admin11]

@Anonymous 

Thank you very much for your help, it work fine now.

Paul