The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
8 | |
4 | |
4 | |
3 | |
3 |