Forum Discussion
Ring dependency detected for second calculated column
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.
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.
I changed it and know it works! 🙂
Thanks a lot!