Running total with condition

[bali1879]

Hi,

I'd calculate the running total in the column sum with specific condition in DAX.
In this case I'd calculate the sum of the order  from the condition order=5 going down with the position.

position	order	sum
1	1	1
2	2	3
3	5	/
4	4	4
5	2	6
6	2	8
7	1	9
8	5	/

Do you have some ideas to do that ? 

[v-diye-msft · Accepted solution]

Hi @bali1879 

Kindly check my below results:

Pbix attached.