Forum Discussion

Whatever2's avatar
Whatever2
Helper I
8 years ago
Solved

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 t...
Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    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

TomMartens's avatar
TomMartens
Super User
8 years ago

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's avatar
Whatever2
Helper I
8 years ago

Oops it does actually work with my slicer , my bad 

i could still use the article thought