Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Circular dependency

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>
DAX
DAX Commands
DAX Commands and Tips
Help me
  • v-cazheng-msft's avatar
    v-cazheng-msft
    4 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , You need to create another measure

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

     

    you should not use measure in a column

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    4 years ago

    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