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.
As a measure.
If 'Facts'[UnitPrice] is a calculated column, this expression
Measure = CALCULATE(SUM(Facts[Turnover])
;'Facts'[UnitPrice]>=50
)
is just a shortcut for:
Measure = CALCULATE(SUM(Facts[Turnover])
;FILTER( ALL('Facts'[UnitPrice])
;'Facts'[UnitPrice]>=50
)
)
If 'Facts'[UnitPrice] is a measure, however, you will get an error message about CALCULATE not being allowed in a filter expression expression (of a CALCULATE expression).
Is it what is happening here?
Yes, 'Facts'[UnitPrice] is a measure.
Then you have your answer. :manhappy:
Ok, so the answer is I can't use a calculated measure in CALCULATE but I can use in FILTER function, correct?