distinct table does not allow unique to unique relationship

[isa_bdr]

Hi to all

I faced several times this issue :

1) create a table distinct()

2) create a relationship with another table

>> and power bi does not allow the one to X relationship

Thanks for you answsers 😉

[MahyarTF · Accepted solution]

Hi,

Would I ask you to share sample data here?

It could be happen when you have null value for the value that is distinct and use as a relationship between main table and distinct table 

Appreciate your kudos and please mark it as a solution if it helps you.