Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 17 | |
| 9 | |
| 8 | |
| 7 |