The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?