Forum Discussion
Circular dependency
Hi guys so i'm quite new to PowerBI. It is an amazing tool but sometimes it is hard.
I have done a lot of research about my problem and i can't quite find a solution so here i am asking for your help.
The problem is i have one column with an amount of money (outstandingAUM[assetsundermanagement]) and i have to make four rows in total that will show a percentage but it's a bit more complicated. the first one is a management fee per day that is easy to calculate as i have made a measurement doing CALCULATE(outstandingAUM[assetsundermanagement] * management fee.
This one is going correct.
Next i want to calculate 3 collumns. The thing is i think i have to do it with an IF function. The first collumn is based on the fee over the amount of 1B, then if it is between 1B - 2,5B the fee is different but only on the part above 1B and under 2,5B and lastly the fee over all above 2,5B.
I will show you guys how i calculated the first one but i got an circular dependency error (which dissapears as soon as i get rid of one of the calculated collumns). I inter in DAX the following.
However adding the management fee calculation this is the result:
These are what the tables look like for your information
Now if anyone has a way around this circular dependency (which i saw on YouTube but i don't know how to implement it in my calculation) or knows how to fix the problem it would be much appreciated!
Thanks upfront!
1 Reply
- amitchandakSuper User
Anonymous , You should not use measure into a calculated column. You should create a new measure. If need use sumx/minx/maxx to create line level calculations
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/