Cumulative sum without date or rank

[Anonymous]

Hello,
I have a dataframe like below;

https://ibb.co/ctLf25g

I want to calculate running total for 'Duration' column(ascending version)
Do I have to rank them first or is there any other way?

All ranking examples work for columns but I need to rank Duration column as measure if needed.

Thanks in advance,

[az38]

Hi @Anonymous 

try a calculated column

Column = calculate(sum(Table1[Duration]);filter(all(Table1);Table1[Duration]<=earlier(Table1[Duration])))

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

[Anonymous]

Hello,

Thank you for your answer but I need measure because I have several slicers so every running sum calculation needs to be remade for every selection.

[az38]

@Anonymous 

no problem

this measure should work 

Measure = calculate(sum(Table1[Duration]);filter(all(Table1);'Table1'[Duration]<=SELECTEDVALUE('Table1'[Duration])))

do not hesitate to give a kudo to useful posts and mark solutions as solution

[Anonymous]

@az38 

Thanks for answer but this formula effects and consider all table.
I want to calculate it dynamically.
In below image it works fine.
https://ibb.co/qW9X0SX
But when I slice Ma_2 it doesn't re-calculate the selection
https://ibb.co/2PRS38m

[Mariusz]

Hi @Anonymous 

Try this Measure

Measure = 
VAR __maxDuration = MAX( 'Table'[Duration] )
RETURN 
CALCULATE(
    SUM( 'Table'[Duration] ),
    ALLSELECTED( 'Table' ), 
    'Table'[Duration] <= __maxDuration 
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[Anonymous]

@Mariusz  Thank you it works, but when they are repetitive values it doesn't sum up until value changes.

For example;
Value   Cumulative.Sum
35         35  
17         52  
15         67 
11         78  
7           92
7           92
3           104

3           104
3           104
3           104
2           106


How can I convert first 92 to 85?

[az38]

@Anonymous 

what's rule do you want to define whats 7 is the first, whats is the second?

its impossible do correct without any additional dimension

do not hesitate to give a kudo to useful posts and mark solutions as solution

[Anonymous]

Hello @az38 

I added the correct version of what I want.
Is it impossible?

For example;
Value   Cumulative.Sum(Wrong)  Cumulative.Sum(Correct)
35                    35                                          35
17                    52                                          52
15                    67                                          67
11                    78                                          78                                                                                
7                      92                                          85
7                      92                                          92
3                      104                                        95

3                      104                                        98 
3                      104                                        101
3                      104                                        104
2                      106                                        106 

[az38]

@Anonymous 

I dont see a way to split 7's values in your data model without addition any other order column

do not hesitate to give a kudo to useful posts and mark solutions as solution