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
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
    )