Running Total

Hi NewbieJono ,

I’d like to acknowledge the valuable input provided by sergej_og . His initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue.  

In my investigation, I took the following steps:

I create a table as you mentioned.

Then I create a new measure and a calculated column.

Measure = 
CALCULATE (
    SUM ( 'Table'[Vol] ),
    FILTER ( ALL ( 'Table' ), 'Table'[Days] <= MAX ( 'Table'[Days] ) )
)

Column = SUM('Table'[Vol])

Finally I create another measure and get what you want.

Measure 2 = DIVIDE('Table'[Measure],MAX('Table'[Column]))

Best Regards

Yilong Zhou

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