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 there is a circular reference as follows:
pod commitment %, miss flag, pod commitment %
but here is the pod commitment column (no miss flag reference at all):
Pod Commitment % = CALCULATE(
DIVIDE(
SUM('Pod Averages'[Production]),
SUM('Pod Averages'[Commitment])+SUM('Pod Averages'[Inflation])
)
)
just for good measure here is the table dax:
Pod Averages = SUMMARIZE('60_DAY_DATA','60_DAY_DATA'[Pod],'60_DAY_DATA'[DateOfData],
"Floor Average", average('60_DAY_DATA'[Floor Average]),
"Commitment",SUM('60_DAY_DATA'[Adjusted Commitment]),
"Production", SUM('60_DAY_DATA'[Total Production]),
"Inflation", SUM('60_DAY_DATA'[Inflation_Amount])
)
I'm about the rip my hair out. I have deleted and remade columns. I need this functional asap! I see no way there is a circular reference. Please help!
Got it working. Was given poor instructions. Apologies, I don't see how to delete this post.
3 Replies
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.
BTW using ALLEXCEPT makes the Pod COmmitment % column all one value, unacceptable solution.
Got it working. Was given poor instructions. Apologies, I don't see how to delete this post.
