Forum Discussion
Solved
Using a Boolean expression with CALCULATE
Can someone explain me why this expression of a calculated measure works: Measure = CALCULATE(SUM(Facts[Turnover]);FILTER('Facts';'Facts'[UnitPrice]>=50)) Whereas this one doesn't: Measu...
- This is correct. No measure or CALCULATE expression, unless you write a full FILTER expression around it.
Yes, 'Facts'[UnitPrice] is a measure.
Then you have your answer. :manhappy:
- This is correct. No measure or CALCULATE expression, unless you write a full FILTER expression around it.
Ok, so the answer is I can't use a calculated measure in CALCULATE but I can use in FILTER function, correct?
For a calculated column, you have the row context active, so row by row you can use the boolen expression. For the measure, there would be no row context active as it would be expected by the boolean expression.
