Circular dependency

[Anonymous]

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!

[amitchandak]

@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/