Sum multiple columns and receiving individual values per row

[Salva]

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

[DOLEARY85 · Accepted solution]

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 👍