topic Re: Circular dependency in DAX Commands and Tips

Circular dependency

Anonymous — Thu, 02 May 2024 11:28:33 GMT

Hello,

can someone help me solve circular depenedncy issue? it is confusing because i am not referring to the culomn at all.
So i want to calculate the number of rows in my table in a cumulative manner for each date. example

ID date Cumulative_number

0 01.01.2020 09:00 1

1 01.01.2020 10:00 2

2 05.05.2020 10:00 4

3 05.05.2020 10:00 4

I have the formula which was actually working but i changed the data source and suddenly it is not working.

Cumulative number= CALCULATE ( [count all IDs], FILTER ( ALL( table), table[date] <= EARLIER ( table[date] ) ) )

Any suggestions on how I can solve the issue?

Re: Circular dependency

lbendlin — Thu, 02 May 2024 18:48:55 GMT

This is a calculated column.

RT rows = var d = [date] return COUNTROWS(filter('table',[date]<=d))

Let me know if you need this as a measure.

Re: Circular dependency

Anonymous — Mon, 06 May 2024 11:58:58 GMT

Thank you this resolves my issue!
I have another culomn that gives the same error. It seems that the calculate (x, filter)) is causing the circular dependency!

ID date Cumulative_number date2 burndown

0 01.01.2020 09:00 1 02.02.2020 10:00 1

1 01.01.2020 10:00 2 02.02.2020 11:00 2

2 05.05.2020 10:00 4 06.05.2020 09:00 2

3 05.05.2020 10:00 4 Blank 2
4 06.05.2020 11:00 5 07.05.2020 11:00 3

Burndown =

VAR CurrentDate = table[date]

VAR cumulativeNumber = table[Cumulative Number] (Which now doesn't have circular dependency anymore)

var PreviousDate=

CALCULATE(

MAX(table[date2]),

FILTER(

table,

table[date2] <= CurrentDate

&& NOT(ISBLANK(table[date2]))

)

RETURN

cumulativeNumber -

COUNTROWS(

FILTER(

table,

NOT(ISBLANK(table[date2])) &&

table[date2] <= PreviousDate

)

)

Any idea how i can change my formula to avoid the circular dependency?

Re: Circular dependency

Anonymous — Mon, 06 May 2024 15:01:01 GMT

I did a little workaround.
I created the columns like this

Cumulative date2= VAR d = table[date] RETURN SUMX( FILTER( table, table[date2] <= d && NOT(ISBLANK(table[date2])) ), 1 ) burndown = cumulative number- cumulative date2

but it is extremely slow whether I use countrows or sumx with 1. and I get a memory max error. Any workarounds in mind?

Re: Circular dependency

lbendlin — Fri, 10 May 2024 00:19:23 GMT