Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Sum multiple columns and receiving individual values per row

Hi,

 

I summed 14 columns of data using the SUMX function but instead of receiving individual values per row, I've recevied one big summed figure. Should I be doing something differently?

 

The formula I used is:

MeassureName = SUMX(TableName, TableName[column a] +TableName[column b] +TableName[column c] ...)

Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi,

     

    add Calculate before SUMX to change to row context. e.g

     

    CALCULATE(SUMX(TableName, TableName[column a] +TableName[column b] +TableName[column c] ...))

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

1 Reply

  • DOLEARY85's avatar
    DOLEARY85
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Hi,

     

    add Calculate before SUMX to change to row context. e.g

     

    CALCULATE(SUMX(TableName, TableName[column a] +TableName[column b] +TableName[column c] ...))

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍