Running Total of "Amount" field based on the "Amount" field itself that contains same figures

[Anonymous]

With the following table, I would like to write a measure that calculates the running total of the "Amount" field based on the sorted "Amount" field.

Input:

Product	Amount
A	5
B	20
C	20
D	50
E	10
F	30

Ideal Output:

Product	Amount	Running Total
D	50	50
F	30	80
B	20	100
C	20	120
E	10	130
A	5	135

But with the following DAX formula "Running Amount", I could not achieve the ideal output as there are two Products with the same Amount, i.e. B and C. Because of this, the FILTER function returns two rows at the same time, which gives the sum of 40, that resulted in the actual output below.

Running Amount = 
CALCULATE(
    SUM(Sheet1[Amount]),
    FILTER(
        ALLSELECTED('Sheet1'),
        Sheet1[Amount] >= MIN(Sheet1[Amount])
    )
)

Actual Output: Instead of summing to 100 from 80, the calculation jumps directly to summing 40 for the next two rows after 80.

Product	Amount	Running Total
D	50	50
F	30	80
B	20	120
C	20	120
E	10	130
A	5	135

Any advice would be greatly appreciated.

[amitchandak]

@Anonymous , Create a rank with Random variable(to break tie)  and try to use that. 

[amitchandak · Accepted solution]

@Anonymous , I create a column

Amount1 = [Amount] + RAND()/10000

and measure

Running Amount = 
CALCULATE(
    SUM('Table'[Amount]),
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Amount1] >= MIN('Table'[Amount1])
    )
)

but position of 100 and 120 can swap

[AllisonKennedy]

You'll have to break the tie. See if this helps, then use it for running total: https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/