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 dependency
Hello, I'm working on a report and I'm facing this issue "A circular dependency has been detected: Calendar[Année-Mois], Calendar[Flag Mois-Années], Calendar [Année-Mois]. So the problem is displayed when I try to sort the column [Année-Mois] by using the column [Flag Mois-Années] below the capture : Here are the measures that I used. Do you have any tips? solutions? Calendar = CALENDAR ("01/01/2020", "12/31/2021") Année = YEAR('Calendar'[Date]) Trimestre = QUARTER('Calendar'[Date]) Mois_nombre = MONTH('Calendar'[Date]) Mois = FORMAT(DATE(2016,'Calendar'[Mois_nombre],1),"MMMM") WeekdayFlag = if(weekday('Calendar'[Date]) = 1,0,if(weekday('Calendar'[Date])=7,0,1)) Année-Mois = CONCATENATE('Calendar'[Mois]," "&'Calendar'[Année]) Flag Month-Year = SWITCH ('Calendar' [Year-Month], "January 2020", 1, "January 2021", 2, "February 2020", 3, "February 2021", 4, "March 2020", 5 , "March 2021", 6, "April 2020", 7, "April 2021", 8, "May 2020", 9, "May 2021", 10, "June 2020", 11, "June 2021", 12, "July 2020", 13, "July 2021", 14, "August 2020", 15, "August 2021", 16, "September 2020", 17, "September 2021", 18, "October 2020", 19, " October 2021 ", 20," November 2020 ", 21," November 2021 ", 22," December 2020 ", 23," December 2021 ", 24) Thank you very much, Regards,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?
