Forum Discussion

garycarters's avatar
garycarters
Helper I
7 years ago
Solved

Creating relationships between two tables.

Hi    I'm trying to achieve a relationship between 3 tables - customer, quote and contract.     For each customer, I want to report on items from both of the two child tables.   Customer is rel...
Need Help
  • BobBI's avatar
    BobBI
    7 years ago

     

    Hi,

     

    to resolve this issue , you can copy your Quote table, stripout all columns except Quote id and description , link this table with customer table. your data model would look like this after the changes. if your table relationships looks different please share table images with related fields.

     

    Cheers!,

    ss

Anonymous's avatar
Anonymous
Not applicable
7 years ago

This is possible. You may just not have been able to figure out why PBI is not letting you do it.

 

What is the error message you are getting?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Try changing the cross filter direction to 'bidirectional'

       

      • garycarters's avatar
        garycarters
        Helper I
        7 years ago

        I presume you mean between quote and contract?  

         

        Tried and it didn't work, same message.

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      7 years ago

      Hi garycarters,

       

      As the issue mentioned, you can created a one-many relationship between table 'customers del' and 'deltickhdr', so you shouldn't add a new relationship between table 'bidhdr' and ''customers del'' because you already have a one-many relationship between table 'bidhdr' and 'deltickhdr', this may cause ambiguity when you try to filter table 'deltickhdr' using 'customers del', I would recommend you delete one of the relationship above or change the table structure you have. 

       

      Regards,

      Jimmy Tao