Forum Discussion

theo's avatar
theo
Helper III
9 years ago
Solved

sum multiple columns, how to?

Hi, Im new in powerBi and Im working in some datat wherein I need to calculate per row with multiple colums. at 1 row for example, i have data like           1.00     1.25    2.00  3.00   4.50   5.0...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago

    Have you tried the proper syntax using SUMX?

    MeassureName = SUMX(TableName, TableName[column a] +TableName[column b] +TableName[column c] ...)

     

    That should do the trick.

     

    Br,

    Magnus

89hasnain's avatar
89hasnain
New Member
3 years ago

I have tried this formula but its showing over all value in every cell of that column

 

 

mexyaa's avatar
mexyaa
New Member
2 years ago

Calculate(SUMX(TableName, TableName[column a] +TableName[column b] +TableName[column c] ...) thias would work

  • Sandeep13's avatar
    Sandeep13
    Helper III
    2 years ago

    Yes its work for me when i used dax like below

     

    TotalTime_ =
    VAR A = CALCULATE(SUMX(MFI,MFI[Time taken in seconds]+MFI[Time taken in seconds_4]+MFI[Time taken in seconds_8]))
    Return
    A

    Sharing dax for other reference