Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |