Circular depency error on UNION table

[rex9311]

Hey all,

I have created a UNION table to create a table with all Customer IDs from two source (one source contains less customer IDs and some 0's). I want to create a one to many relationship so that I can work with the sales and forecast data from the two different tables. However, I am getting a circular depency error, see below. What could I do to solve this? Thanks. Rex

[amitchandak]

@rex9311 , use distinct

distinct(union(distinct(Table1[Customer ID]),distinct(Table2[Customer ID])))

[rex9311]

Hey Amit,

Thanks but now a many-to-many relationship is the only one available. See below, how can I make it a one to many? Because a customer can have multiple saleslines but a salesline can only have one customer.