How to sum multiple columns across

Question

I've seen SUMX that will sum mutiple column values in one row but is it possible to do the same per column?

columns A B C D ....(i have around 44)

Row_1 1 1 1 1

Row_2 1 1 1 1

Row_3 1 1 1 1

......

Total 3 3 3 3

i want the totals per columns in power bi

i can drag my columns into a card but it does count and no SUM option

i dont want to manipulate the data in Excel

thanks

truptis · Accepted Answer

Hi&nbsp;CarlZ22&nbsp;,Not very clear with your requirement but if you want a sum of a particular column, then you can use SUM([ColumnName])

Forum Discussion