Relationship - Distinct table

[jorismo]

Hi all,

I've got the 'cant create an relationship ... one of the columns must have unique values' error.

This because I want to create an relationship between 2 tables. One table (Tickets) is imported via sql query, the second one is created via 'New Table' and the formula: Assignee = DISTINCT(Tickets[Assignee]).

So the Assignee table contains unique values or am I wrong at this?

Thanks

[jorismo · Accepted solution]

Ah I solved it by myself

There where some open values, I've replaced them by unassigned value and this solves the issue.