relationship unique value

[Whatever2]

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 

[TomMartens · Accepted solution]

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

[Whatever2]

Oops it does actually work with my slicer , my bad 

i could still use the article thought

[Whatever2]

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