Forum Discussion
Multiple one to many relationships
I have been trying for a while to create two many to one relationships. Both from a look up table to a normal table. From OperatorGroups to Incidents and Incidenttypes to Incidents. With the relation between each being set with: Incidents typeId > IncidentTypes id > Incidents and Incidents operatorGroupId > Incidents id
One operator group can have multiple incidents. One incident type can have multiple incidents. Yet, Power BI doesn't like it when I active more than one of these relations. When I click the ''Make this relationship active'' checkmark I get the following error.
The cross filter direction is set to Single. I'm not sure why it gives this error because I figured these two relations are sound.
Your incidenttypes table filters your departments table which then filters Operator Groups. You will need to use an inactive relationship on one side or the other (and the USERELATIONSHIP function to activate it within the needed measures).
Pat
4 Replies
- amitchandak
Super User
Anonymous , Either there is a loop, or there two paths you can reach from incident type to incidents.
Please check and try to address that. Or share full diagram
- mahoneypat
Microsoft Employee
Your incidenttypes table filters your departments table which then filters Operator Groups. You will need to use an inactive relationship on one side or the other (and the USERELATIONSHIP function to activate it within the needed measures).
Pat
