Forum Discussion
Multiple one to many relationships
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
Super UserAnonymous , 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
Hope the screenshots are clear enough.
I'm not sure where there would be a loop.
- 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
This was the solution, thank you.