Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

SUMX Easy Example

Hi,   Can someone explain why the grand total is not 150 + 275 + 185 + 265 = 875? I thought SUMX iterates over a table and returns the sum of the expression.   Thanks    
Need Help
  • speedramps's avatar
    speedramps
    4 years ago

    Try this instead

    test = SUMX(Sheet1,Sheet1[x] + Sheet1[y])

    and check the answer on each row and the total

     

    Think the way you have written the expression is summing the grand total for each record .

    I assume you have 5 records on your input table and 5 x 875 = 4375

aj1973's avatar
aj1973
Community Champion
4 years ago

Hi Anonymous 

in test = SUMX(sheet1, x+y) the filter context has changed.

Keep it simple and just use test = X+Y