Forum Discussion

Anika3186's avatar
Anika3186
Frequent Visitor
3 years ago
Solved

Ring dependency detected for second calculated column

Hello,   I got an error message on a calculated column. Initial situation: I created a table and a calculated column that gives me sales divided by sales:   Average Retail Price = DIVIDE(SalesD...
  • HotChilli's avatar
    3 years ago

    Right, so there's the problem.

    I think the first thing to say is that calculated columns should not use measures.  That is not good practice.  The next thing to do is find a solution for the issues here.

    Maybe you can rewrite Average Retail Price without using measures (it's possible that circular dependency errors will continue since I haven't seen your data or model)) or do it in Power Query.

    I think those are good starts.