Forum Discussion
Viatos1_1
3 years agoRegular Visitor
Circular relationship
I have three tables:
Person Skills: {Person A: Skill A, Skill B, ... ; Person B: Skill B, ...}
Person Roles: {Person A: Role A; Person B: Role B}
Role Skills: {Role A: Skill B, ... ; Role B: Skill B, ...}
I need to answer question: what skills necessary for a role does a person have in PowerBI.
It creates a circular relationship because firstly I need to filter Person Skills by person, then person roles by person, then role skills by role, and finally person skills by skills from selected role.. Could someone help me to solve this?
No RepliesBe the first to reply