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.
