Forum Discussion
relationship unique value
hello everyone
I'm trying to create a table that contains 2 related ID but when i try to link it to my other table i get this message :
does anyone know how to tell Power bi it's okay not to have unique values ?
thanks in advance
Hey,
currently it' not possible to create a relationship between two tables where no table has unique values in the column that defines the relationship.
Maybe you can consider the following:
Create an extra table that just contains one column that holds unique values for "quote_no"
You can use the DAX function DISTINCT to create this table.
This table than can be used to indirectly connect the other two tables.
Here is an article that describes how different "fact" tables can be related, don't get confused by the title of the article.
Hopefully this gives you an idea
Regards
Tom
3 Replies
Hey,
currently it' not possible to create a relationship between two tables where no table has unique values in the column that defines the relationship.
Maybe you can consider the following:
Create an extra table that just contains one column that holds unique values for "quote_no"
You can use the DAX function DISTINCT to create this table.
This table than can be used to indirectly connect the other two tables.
Here is an article that describes how different "fact" tables can be related, don't get confused by the title of the article.
Hopefully this gives you an idea
Regards
Tom
thanks for you response
but your trick to create one table with only the quote_no doesn't to work for me , i manage to create the relation between the table but my slicer don't work .
aswell i think you forgot the link to the article you're talking about
regards
Oops it does actually work with my slicer , my bad
i could still use the article thought
