Hi,
I’m having an issue with circular dependencies I am using the two formulas below.
2017 Repair Count = CALCULATE(COUNTA('Job Summary Josh Test'[place_ref]),USERELATIONSHIP('Job Summary Josh Test'[place_ref],'Repair Count'[place_ref]),'Job Summary Josh Test'[COMP_FISCAL_YEAR_TEXT] ="FY 2017")
alpha Number Of Repairs Groups =
VAR x = 'Repair Count'[2017 Repair Count]
RETURN
SWITCH(
TRUE(),
x >= 0 && x <= 5, "Between 0 and 5",
x >= 6 && x <= 10, "Between 6 and 10",
x >= 10 && x <= 30, "Between 10 and 30",
x >= 30 && x <= 90, "Between 30 and 90",
x >= 90 && x <= 150, "Between 90 and 150",
"150+ and above"
)
When I use this formula I get the following message
A circular dependency was detected: Repair Count [2017 Repair Count], Repair Count[alpha number of repairs groups],repair Count[2017 Repair Count]
Why is this an issue and how can I resolve this issue going forward.
Any and all help is greatly appreciated.
