Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Hidden relationship?

I imported a few entities from Microsoft CRM using the OData Feed. When I tried to create a relationship between two of the tables (systemusers and tasks), it automatically made the relationship inac...
Need Help
  • Stachu's avatar
    Stachu
    6 years ago

    the message actually says it quite clearly. Currently there is a following setup:

    1. 'queues' => 'systemusers'
    2. 'queues' => 'trs_tasktypes'=>'tasks'

    so if you add 'systemusers'=>'tasks' then filter on 'queues' could follow 2 paths to filter 'tasks': either the path 2. or this one:

    • 'queues' => 'systemusers'=>'tasks'

    which causes the ambiguity. The question is which logic you want to implement. If it difers per case then you can activate the inactive relationship by using USERRLATIONSHIP, e.g. in CALCULATE https://dax.guide/userelationship/

    more general info on relationships (around 14:30 Alberto starts talking about ambiguity):

    https://www.sqlbi.com/tv/understanding-relationships-in-power-bi/

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi Anonymous ,

I'm not certain whether your the scenario like this:

When you try to create active relationship between table and table2, it will show this message:

That could be there has indirectly relationships between these tables so that you should enable one of the relationship or change the Cross filter direction.

Please refer:

  1. https://radacad.com/what-is-the-direction-of-relationship-in-power-bi
  2. https://docs.microsoft.com/en-us/power-bi/desktop-bidirectional-filtering

If not like the previous scenario, could you please share more details about some pictures or error messages for further discussion?

 

Best Regards,

Yingjie Li

 

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