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 f...
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 👍

DOLEARY85's avatar
DOLEARY85
Resident 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 👍