Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Viatos1_1
Regular 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? 

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.