Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
A circular dependency was detected: timbratura[time FG mancante log], timbratura[FG mancante log], timbratura[time FG mancante log].
I already write a formula to find a count with this formula
FG mancante log = calculate(COUNTROWS(timbratura);FILTER(FG;FG[Sintomi L3]="MANCANTE"); FILTER(FG;FG[Team Provenienza]="LOGISTICA");FILTER(FG;OR(FG[Descrizione Difetto]="GO";FG[Descrizione Difetto]="STOP")))
But i want now the sum of time
time FG mancante log = calculate(SUM(timbratura[tempo FG]);FILTER(FG;FG[Sintomi L3]="MANCANTE"); FILTER(FG;FG[Team Provenienza]="LOGISTICA");FILTER(FG;OR(FG[Descrizione Difetto]="GO";FG[Descrizione Difetto]="STOP")))
but there is a pb. someone know why?
Solved! Go to Solution.
I can only speculate but it seems like perhaps timbratura[tempo FG] might somehow reference timbratura[FG mancante log]?
Same issue How to Solve
A circular dependency was detected: s[Available mins Batch], s[EARNED MINS BATCH], s[Available mins Batch].
I can only speculate but it seems like perhaps timbratura[tempo FG] might somehow reference timbratura[FG mancante log]?