Running Total Dax help

hello everyone, I am trying to do basic running total in power bi. Its based on Stop I have to do the total. Any help/suggestion please on this. stop total running total 1 5 5 2 3...

Need Help

v-alq-msft

Community Support

6 years ago

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.

srinivas258

Helper I

6 years ago

Hi v-alq-msft , amitchandak ,

Apologies for not being clear. Stop and Total are from same table. I have an other column (Stop Description) from other table and I would like to add that to this Running Total table. And there is join in place between these two tables. I tried using lookupvalue for had no luck.

Forum Discussion

Running Total Dax help