To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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.
User | Count |
---|---|
14 | |
11 | |
6 | |
6 | |
5 |
User | Count |
---|---|
29 | |
17 | |
11 | |
7 | |
5 |