True/false expression does not specify a column

[gvg]

Hi folks,

I am trying to override page level filter on Product with this measure, but it complains that "true/false expression does not specify a column". What am I doing wrong here?

SumAmount8 =
  CALCULATE
      (
         SUM
            (  Sales[Amount]
            ),
            all( Sales[Product] ),
            left( Sales[Product] ),1="8"
      )

 Thanks.

[Anonymous · Accepted solution]

Hi @gvg,

You messed up with parenthesis here I guess:

SumAmount8 = CALCULATE(SUM(Sales[Amount]),all(Sales[Product]),left(Sales[Product],1)="8")

HTH,

Pawel

[gvg]

Did I? I think the parenthesis are ok. Edited measure definition in better order.
I am trying to use two filters in CALCULATE. Let's say I have Product="7" as a page filter. I need to override this filter to sum on all products that start with 8.

[gvg]

@Anonymous  Sorry, you are right, I misplaced one parenthesis. But I still  do not get the expected result.