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 ...
  • 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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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