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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MilanAXVII
Helper I
Helper I

circular dependency was detected

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?

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

I can only speculate but it seems like perhaps timbratura[tempo FG] might somehow reference timbratura[FG mancante log]?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Ajithkumar
Regular Visitor

Same issue How to Solve 

 

A circular dependency was detected: s[Available mins Batch], s[EARNED MINS BATCH], s[Available mins Batch].

Greg_Deckler
Super User
Super User

I can only speculate but it seems like perhaps timbratura[tempo FG] might somehow reference timbratura[FG mancante log]?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.