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.