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
Mikelytics's avatar
Mikelytics
Resident Rockstar
3 years ago

Hi Kasiop 

 

Please try the following

 

 SUMX(
   VALUES(Cost[Type]), 
   cost(jan) + cost(feb)+ ...) 
)

 

If this does not help please provide a piucture of your data model with relevant columns as well as how your current result looks in Power BI.

 

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn

Kasiop's avatar
Kasiop
Helper II
3 years ago

Hi, 

I didnt manage to make your formula works...

All my data are in one column called CL: 

 

And here is the powerbi visual:

 

 

  • FataiSanni's avatar
    FataiSanni
    Advocate III
    3 years ago

    Hi,

    I believe this should work, based on the table you posted.

     

     SUMX(
   'CL', 
   Jan + Feb + Mar + Apr +...
)

     

    Alternatively, I will advise you to unpivot the month columns and have all Months in a single column and values in another column. That way, SUM(Values) will just work.

    • Kasiop's avatar
      Kasiop
      Helper II
      3 years ago

      htanks,  but still not working :

      CL SUM2 = SUMX(
      'CL',
         CL[Jan] + CL[Feb] + CL[Mar] + CL[Apr] + CL[May]+  CL[Jun]+  CL[Jul]+  CL[Aug]+  CL[Sep]+  CL[Oct]+  CL[Nov]+  CL[Dec]
      )
       
      I still have the global total.
      Kasiop