Running Total Dax help

Hi, srinivas258 

Based on your description, I created data to reproduce your scebario.

Table:

You may create two measures as below.

Total = 
var _stop = SELECTEDVALUE('Table'[Stop])
return
SUMX(
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Stop]<=_stop
    ),
    'Table'[Stop]
)

Running Total = 
var _stop = SELECTEDVALUE('Table'[Stop])
var tab = 
ADDCOLUMNS(
    ALLSELECTED('Table'),
    "Total",
    CALCULATE(
        SUM('Table'[Stop]),
        FILTER(
            ALLSELECTED('Table'),
            'Table'[Stop]<= EARLIER('Table'[Stop])
        )
    )
)
var newtab = 
ADDCOLUMNS(
    tab,
    "Runnung Total",
    var t = [Total]
    return
    SUMX(
        FILTER(
            tab,
            [Total] <= t
        ),
        'Table'[Total]
    )
)

return
SUMX(
    FILTER(
        newtab,
        [Stop] = _stop
    ),
    [Runnung Total]
)

Result:

I wonder what the column from another table is like and if there is a relationship between two tables.

Best Regards

Allan

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