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.
In what sense does the second formula "not work"? It appears to work fine in my test.
Hello,
I get the error:
This means something like: "A CALCULATE function was used in a TRUE/FALSE expression as a table filter. This is not allowed".
And this message gets me even more confused.
However, the following function works perfectly:
Are you adding that formula as a measure or a column?
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?