Forum Discussion

gvg's avatar
gvg
Post Prodigy
9 years ago
Solved

True/false expression does not specify a column

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.

Show and Tell
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      gvg
      Post Prodigy
      9 years ago

      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's avatar
        gvg
        Post Prodigy
        9 years ago

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