Forum Discussion
Measure as calculated column, circular dependency
Hello,
I have a rather conceptual question here:
Given I have several measures which are like
Measure=
Var
Table A=...
Var
Table B=...
return
Calculate ( Sum (sales),
Except )(Table A, Table B))
Now I have a problem with filtercontext so I put these values in a immutable calculated column:
Column = Measures[Measure]
The first one is not problem, but why do I get a circular dependency if I make exactly the same measure, but this time, I
count the orders:
Calculate ( Count (Orders),
Except )(Table A, Table B))
Is there something I can do to modify the Calculate function to make it work?
Best.
The best explanation of what is happening is in:
Avoiding circular dependency errors in DAX - SQLBI
When you use CALCULATE in a calculated column it forces context transition which moves all of the columns included any calculated columns into the filter context. Although your new calculated column doesn't need the first one the presence of CALCULATE makes it depend on it.The solution is to use ALLEXCEPT or REMOVEFILTER in your CALCULATE statements to prevent them being involved in context transition.
1 Reply
The best explanation of what is happening is in:
Avoiding circular dependency errors in DAX - SQLBI
When you use CALCULATE in a calculated column it forces context transition which moves all of the columns included any calculated columns into the filter context. Although your new calculated column doesn't need the first one the presence of CALCULATE makes it depend on it.The solution is to use ALLEXCEPT or REMOVEFILTER in your CALCULATE statements to prevent them being involved in context transition.