Forum Discussion

Kasiop's avatar
Kasiop
Helper II
3 years ago

SUM Issue

Dear Community,    I have a simple issue using "sum"...  I have a table with multiple lines, linked an id/category but when I try to have the total cost per category, here which is supposed to be ...
Need Help
FataiSanni's avatar
FataiSanni
Advocate III
3 years ago

Hi,

 

I'm assuming you are creating a measure, try this instead 

 

Total Cost = sum('Table'[Cost Jan]) + sum('Table'[Cost Feb])

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • Kasiop's avatar
    Kasiop
    Helper II
    3 years ago

    Thanks a lot, I tried to implement your solution but I am not sure what I am doing wrong but the formula still show me the "wrong" total cost:

    CL SUM = SUM('CL'[Jan])+ SUM ('CL'[Feb])+ SUM ('CL'[Mar])+ SUM ('CL'[Apr])+ SUM ('CL'[May])+ SUM ('CL'[Jun])+ SUM ('CL'[Jul])+ SUM ('CL'[Jul])+ SUM ('CL'[Aug])+ SUM ('CL'[Sep])+ SUM ('CL'[Oct])+ SUM ('CL'[Nov])+ SUM ('CL'[Dec]).