Forum Discussion

Bhargav150's avatar
Bhargav150
Frequent Visitor
2 years ago

Create relationship between multiple datasets

I have 4 datasets in power bi Skills,Panel, Daily slot utilisation, summary of daily slot utilisation, and I'm trying to create a relationship between skills to Daily slot utilisation and summary of daily slot and panel to Daily slot utilisation and summary of daily slot in cross filter direction as both but for the skills to daily slot utilisation is becoming inactive why? When I'm try to activate this error coming

 

You can't create a direct active relationship between daily slot utilisation and skills because that would introduce ambiguity between tables skills and Panel. To make this relationship active, deactivate or delete one of the relationships between skills and panel first

1 Reply

  • ValtteriN's avatar
    ValtteriN
    Community Champion
    2 years ago

    Hi,

    Here is a simplified example what causes these kinds of errors:

    Consider this picture. Here if I try to activate the relationship between calendar and invoices the same error arises. This is because if the relationship would be active there would be two paths from where the calendar filters transactions. Either directly or via Invoices. In your case the bi-directional relationship would cause similar behavior.