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?
Circular relationship
Hello, I´m creating a new Report and need to create a relationship between the Date and Customers tables to calculate de number of Customers whose registration date is equal to the selected date. I can´t create this relationship because this causes a circular relationship. Can you help me to solved this problem?
