Forum Discussion
Ring dependency detected for second calculated column
- 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.
Are we getting the full information here?
Is Average Retail Price column using measures or calculated columns or 'normal' columns?
The Average Retail Price column is a calculated column, I created: DIVIDE(SalesData[Sales CY], SalesData[QTY CY])
And this calculated column uses measures in the formula (Sales CY & QTY CY are measures)