Count multiple columns

[Anonymous]

Hello

Good Morning !

I have a table with 31 columns that have values ​​equal to 1 or 0.

I need to know how many times the number 1 appears in all columns, does any have any suggestions other than calculate and count 31 time?

Thank you so much in advance

[amitchandak · Accepted solution]

@Anonymous , On of the way is unpivot and make one column then you can sum up the new column.

Or

Sumx(Table, [Col1]+[Col2]) //Add all 31