Forum Discussion

andy_scott42's avatar
andy_scott42
Icon for Helper II rankHelper II
6 years ago
Solved

Relationship between multiple facts

I have 2 fact tables that I need to somehow relate to common dimension. I can't make all the relationships active as it will lead to ambiguity.     Spaces contains the information about my R...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi andy_scott42 ,

     

    For the relationship, recommend you create the star schema instead of circle schema, so you may delete the secondary relationship between table Orders and Assets, and change the Cross filter direction of relationships among the these tables above from Single to Both , which will take these tables treated as a single table. Then when you make some changes in someone table, the other table objects will return corresponding matched result. See more:Create and manage relationships in Power BI Desktop .

     

     

     

     

     

     

     

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

andy_scott42's avatar
andy_scott42
Icon for Helper II rankHelper II
6 years ago

Thanks Amy v-xicai 

 

That seems to have fixed my issue and enabled the filters to work as expected.

 

However this has changed the value of my measures so I'm not sure it is the correct solution.

 

I was under the impression that setting filters to bi-directional was bad practise as it leads to performance errors and incorrect measure values?

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi andy_scott42 ,

 

You may need to change the formula of measure according to the fact value.

 

Best Regards,

Amy