Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Help With Table Relationships

Hi Guys,   I am hoping someone can help me with the Power BI relationship.  I have 5 tables:   dweekly – lookup table based on the dates from the Fleet_Weekly table Site – lookup table Brand –...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi Anonymous,

     

    First you should know that in Power BI, you are only able to create one inactive relationship between two tables.

     

    However since all the relationships you have set to Both Cross Filter Direction. It means there already exists an inactive relationship between Site and Brand. The path will be Site -> Sales Weekly -> Brand.

     

    And now you want to create a new relationship between Site and Fleet Weekly, then a second relationship between Site and Brand will be generated as Site -> Fleet Weekly -> Brand. That's why the error occurs.

     

    To resolve your issue, you can set the Cross Filter Direction to Single for the relationships " Site and Sales Weekly " and " Brand and Fleet Weekly ".

     

    Thanks,
    Xi Jin.

v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

Hi Anonymous,

 

First you should know that in Power BI, you are only able to create one inactive relationship between two tables.

 

However since all the relationships you have set to Both Cross Filter Direction. It means there already exists an inactive relationship between Site and Brand. The path will be Site -> Sales Weekly -> Brand.

 

And now you want to create a new relationship between Site and Fleet Weekly, then a second relationship between Site and Brand will be generated as Site -> Fleet Weekly -> Brand. That's why the error occurs.

 

To resolve your issue, you can set the Cross Filter Direction to Single for the relationships " Site and Sales Weekly " and " Brand and Fleet Weekly ".

 

Thanks,
Xi Jin.