Forum Discussion

webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
10 years ago
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...
  • LaurentCouartou's avatar
    LaurentCouartou
    10 years ago
    This is correct. No measure or CALCULATE expression, unless you write a full FILTER expression around it.
Anonymous's avatar
Anonymous
Not applicable
10 years ago

In what sense does the second formula "not work"? It appears to work fine in my test.

webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
10 years ago

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:


  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Are you adding that formula as a measure or a column?

    • webportal's avatar
      webportal
      Icon for Impactful Individual rankImpactful Individual
      10 years ago

      As a measure.

      • LaurentCouartou's avatar
        LaurentCouartou
        Icon for Solution Supplier rankSolution Supplier
        10 years ago

        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?