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(...
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

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