topic Circular dependency in DAX Commands and Tips

Circular dependency

Anonymous — Tue, 03 May 2022 16:43:53 GMT

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>

Re: Circular dependency

amitchandak — Wed, 04 May 2022 01:30:48 GMT

Anonymous , You need to create another measure

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

you should not use measure in a column

Re: Circular dependency

v-cazheng-msft — Tue, 10 May 2022 02:32:10 GMT

Hi Anonymous,

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