Forum Discussion
Solved
Circular Reference error with no circular reference
I am receiving a circular reference error where there is no circular reference. This column: Miss Flag = IF('Pod Averages'[Pod Commitment %]<('Pod Averages'[Floor Average]-0.25),1,0) says t...
Got it working. Was given poor instructions. Apologies, I don't see how to delete this post.
The issue may stem from how SUMMARIZE() works. The Pod Averages table is being created via SUMMARIZE(), but calculated columns within it might be causing an implicit dependency loop.
Instead of using SUMMARIZE(), use ADDCOLUMNS() to ensure Power BI correctly tracks dependencies:
Please mark this post as solution if it helps you. Appreciate Kudos.