Forum Discussion

LYorkToenniges's avatar
LYorkToenniges
Icon for Helper III rankHelper III
1 year ago
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...
Need Help
  • LYorkToenniges's avatar
    LYorkToenniges
    1 year ago

    Got it working.  Was given poor instructions.  Apologies, I don't see how to delete this post.

andrewsommer's avatar
andrewsommer
Icon for Super User rankSuper User
1 year ago

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.