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
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.