Circular dependency

[eliasayy]

Hello, i was trying to find the delta variance of 2 columns minutes from table A and minutes from table B.

i used this formula in column inside table B :

Delta =CALCULATE(SUM(TableA[Minutes])-SUM(TableB[Minutes]))

then i needed to find the percentage in Table B by creating a column which is percentage =  delta/ Table A[minutes]

but i get error <pi>A circular dependency was detected: TableB[Delta], TableB[Column], TableB[Delta].</pi>

[v-cazheng-msft · Accepted solution]

Hi @eliasayy,

To resolve circular dependency issues, you could consider these solutions.

1 Change Calculated column to Measure as amitchandak said

2 Modify your Calculated column formula with some filters functions like REMOVEFILTERS

3 Make some changes to the relationships in your model

Please take a look at this blog related to how to fix issue of Circular Dependency: Circular Dependency between Calculated Columns in ... - Microsoft Power BI Community. Hope it helps you.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[amitchandak]

@eliasayy , You need to create another measure

Delta % = divide( [Delta], SUM(TableA[Minutes]))

you should not use measure in a column