Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Sum/Filter Help

I'm stumped!      I have the following measure:   SAS_Testing:= SAS-TESTING = CALCULATE(SUM(Table1[AMOUNT]),ALL('Name'[NAME]),Table1[Dept]="SAS", Table1[sales_id]=0,table1[product_id]="GENOH")...
Need Help
Floriankx's avatar
Floriankx
Solution Sage
8 years ago

Hello,

 

Is your product id numeric?

In your first sample you write [product_id]="GENOH".

 

I'm wondering that calculate can handle this equations as filter. I expected, you have to wrap it in a FILTER formula. But obviously that's not an issue.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    The column is alphanumeric (but typically contains all text).  I'm wondering if max is the wrong operator to be using to handle strings

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago

      Anonymous

       

      Try this

       

      SAS-TESTING =
VAR mymeasure = [sas-max]
RETURN
    CALCULATE (
        SUM ( Table1[AMOUNT] ),
        ALL ( 'Name'[NAME] ),
        Table1[Dept] = "SAS",
        Table1[sales_id] = 0,
        table1[product_id] = mymeasure
    )