Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to sum rows correctly?

Hi, I have created the below measure but the Total is incorrect. Here is the pbix file.

 

Volume Impact Total = SUMX (VALUES('Calendar'[YearMonth]), [Vol Impact])

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , try like

     

    Volume Impact Total = SUMX (ADDCOLUMNS(SUMMARIZE('Append Table','Calendar'[YearMonth],'Append Table'[Product]),"_1", [Vol Impact]),[_1])
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi amitchandak , thanks for your suggestion. It doesn't work for my case. The sum from 2021-06 to 2021-09 is not showing up.