Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
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.
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.
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
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?
User | Count |
---|---|
25 | |
11 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
7 |