Forum Discussion
webportal
9 years agoImpactful Individual
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...
- 9 years agoThis is correct. No measure or CALCULATE expression, unless you write a full FILTER expression around it.
webportal
9 years agoImpactful Individual
Ok, so the answer is I can't use a calculated measure in CALCULATE but I can use in FILTER function, correct?
LaurentCouartou
9 years agoSolution Supplier
This is correct. No measure or CALCULATE expression, unless you write a full FILTER expression around it.