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 September 15. Request your voucher.
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.
User | Count |
---|---|
14 | |
12 | |
8 | |
6 | |
5 |
User | Count |
---|---|
29 | |
19 | |
13 | |
8 | |
5 |