Creating a cumulative sum based on filters in the table

[Allav]

Hi All,

I am struggling to solve the below case. I want to do a cumulative sum of the "dosage" column based on the "Case ID_Milestone" key and runing based on the "date" column. instead, I am getting a sum of all the dosage of all the dates combined, not as runing total based on the date. what am I missing?

also, I would like to add another column of the cumulative %, would appreciate your suggestions on how to do it as well

[Allav · Accepted solution]

was able to solve it! I used:

Cumulative Dosage =

CALCULATE

(SUM ('Daily Dosage'[Dosage]),

FILTER(ALLEXCEPT('Daily Dosage','Daily Dosage'[Case ID_Milestone]),

('Daily Dosage'[date]<=EARLIER('Daily Dosage'[date]))))

basically changed the MAX to EARLIER and it worked!