Circular reference error in calculated column when adding second one

[SajjadMousavi]

Hi.

I have a table and have added this calculated column with no problem:

RunningTotalTransWeight = CALCULATE(SUM(InventTrans[TransWeight]), InventTrans[TransDate] <= EARLIER(InventTrans[TransDate]))

Now I want to add another one with this code:

RunningTotalFinancialCostAmount = CALCULATE(SUM(InventTrans[FinancialCostAmount]), InventTrans[TransDate] <= EARLIER(InventTrans[TransDate]))

When I want to save it, I receive this error:

A circular dependency was detected: InventTrans[RunningTotalFinancialCostAmount], InventTrans[RunningTotalTransWeight], InventTrans[RunningTotalFinancialCostAmount].

Codes for both columns are almost the same, just the field which calculation is based on differs. Why this happens?

Thanks in advance.

[SajjadMousavi]

Thank you both @MahyarTF and @MFelix . According to links you provided, I added an index column and applied ALLEXCEPT on it to change Power BI behavior.

[MahyarTF · Accepted solution]

Hi, 

As I saw in your codes, you are using the dependency code and you need to change your code to fix the issue.

please have a look at the below article :

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

[MFelix]

Hi @SajjadMousavi,

What's is hapenning is related with the context transiction

Please check this blog post with a detailed explanation

https://community.powerbi.com/t5/Community-Blog/Circular-Dependency-between-Calculated-Columns-in-a-...

To what I can understand you want to calculate cumulatives values is this correct?  In this case I advise for you to use a measure instead of calculated columns they will not be dependent on this context transiction and will be much more flexible in the use.