Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello,
I have a these measures:
1 week= CALCULATE(SUM(Table[amount]), Table[Bucket] = "1 week")
1 month= CALCULATE(SUM(Table[amount]), Table[Bucket] = "1 month") + 1 week
runoff1week=[1 week] * Table[runvalueWeek]
These measure are working fine.
But when I create a new measure for runoff1month,
runoff1month=[1 month] * Table[runvalueMonth]
I am getting error in this one saying: " Circular dependency was detected"- runoff1month, runoff1week, runoff1month"
Why so?
How can I fix this?
@amitchandak , @Fowmy , @Anonymous , @daxer-almighty
Please help.
Thanks
Solved! Go to Solution.
Got the solution for this:
1) Used ALLEXCEPT function in the measure to remove the context filters.
2) Other option which I tried is creating a measure for BUCKET instead of column.
Got the solution for this:
1) Used ALLEXCEPT function in the measure to remove the context filters.
2) Other option which I tried is creating a measure for BUCKET instead of column.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
7 | |
5 | |
4 | |
3 |
User | Count |
---|---|
12 | |
11 | |
10 | |
9 | |
8 |