Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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!