Forum Discussion

gvg's avatar
gvg
Icon for Post Prodigy rankPost 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 ...
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

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
    Icon for Post Prodigy rankPost 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
      Icon for Post Prodigy rankPost Prodigy
      9 years ago

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