Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance 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 | |
1 | |
1 | |
1 |
User | Count |
---|---|
8 | |
4 | |
4 | |
3 | |
3 |