I’m having an issue with the CALCULATE function that I can’t quite solve.

This below seems to work fine.

`Measure = CALCULATE(SUM(Facts[Turnover]);FILTER('Facts';'Facts'[UnitPrice]>=50))`

But this one does not and I get a weird error

`Measure = CALCULATE(SUM(Facts[Turnover]);'Facts'[UnitPrice]>=50)`

The error I receive is the below…

“A CALCULATE function was used in a TRUE/FALSE expression as a table filter. This is not allowed”.

Bit confused on this one because I believe that you could do either here and there is no problem.

Maybe I am confused regarding the use of measures inside of CALCULATE and/or FILTER. I’m not sure.

Thanks