Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count multiple columns

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's avatar
    amitchandak
    5 years ago

    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

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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