Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Many-One Relationship when there are Unique values in both tables

I am attempting to link togther two tables that both have unique values, however, it is not allwoing me to make a one:one relationship- instead making a many:one relationship.   I have checked in E...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello Neeko,

 

Thanks for your reply.

I know how to edit teh relatiosnhips but Power bi is not accepting the one:one cardinality taht it shoudl be.

For some reason, it is detecting dupliacte values in one of the tables which are unique.

 

Kind Regards, Adam P

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

This is due to the design, and one-to-one relationships are not supported when there are duplicate values in the table.
You can use the values() function or the distinct() function to create a table with deduplicated values. Then establish a one-to-one relationship with the new table.

Please refer to my PBIX file.

 

Best Regards,

Neeko Tang

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    I think the issue was buggy source data- a new file I loaded in is now allowing the one:one relationship.

     

    Thank you very much for yor help, I apprecite you taking the time.

     

    Adam P

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Anonymous 

    I created a new table using Value Function and Distinct Function respectively and it is still not allowing me to create one:one relationship with either of the calculated tables

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago