The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am receiving a circular reference error where there is no circular reference. This column:
Solved! Go to Solution.
Got it working. Was given poor instructions. Apologies, I don't see how to delete this post.
Got it working. Was given poor instructions. Apologies, I don't see how to delete this post.
BTW using ALLEXCEPT makes the Pod COmmitment % column all one value, unacceptable solution.
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.
User | Count |
---|---|
77 | |
75 | |
36 | |
31 | |
28 |
User | Count |
---|---|
106 | |
98 | |
55 | |
49 | |
48 |