Forum Discussion

PBI_newuser's avatar
PBI_newuser
Post Prodigy
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

    PBI_newuser , try like

     

    Volume Impact Total = SUMX (ADDCOLUMNS(SUMMARIZE('Append Table','Calendar'[YearMonth],'Append Table'[Product]),"_1", [Vol Impact]),[_1])
    • PBI_newuser's avatar
      PBI_newuser
      Post Prodigy
      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.