Rolling sum based on a measure

[a_shamsuzzoha]

I have the following visual.A and B are table columns and C is a calculated measure. Can you created a rolling sum of B based on ascending order of C?

Thanks in advance.

[v-lionel-msft]

Hi @ashamsuzzoha ,

What is the DAX formula for your measure [C]?
I need a complete sample data model.
Or you can refer to my .pbix file.
My [C] is a sorting of [A], so I add up according to [A] to avoid using measure [C].

Best regards,
Lionel Chen

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

[ashamsuzzoha]

Can you do it without changing C to a calculated column?

[v-lionel-msft]

Hi @a_shamsuzzoha ,

First, change column [C] to calculated column.

Measure = 
CALCULATE(
    SUM([B]),
    FILTER(
       ALLSELECTED(Table),
       [C] <= MAX([C])
    )
)

Best regards,
Lionel Chen

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

[a_shamsuzzoha]

Any help?

[amitchandak]

@a_shamsuzzoha , ascending order C or A ?

C can be a measure like

C =calculate(Sum(Table[B]), filter(allselected(Table), Table[A] <=max(Table[A])))

[a_shamsuzzoha]

@amitchandak Ascending order C