Forum Discussion

srinivas258's avatar
srinivas258
Helper I
6 years ago

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
amitchandak's avatar
amitchandak
Super User
6 years ago

srinivas258 ,

Try like

CALCULATE(SUM(Table[Total]),filter(all(Table),Table[stop] <=max(Table[stop])))

Or
CALCULATE(SUM(Table[Total]),filter(allselected(Table),Table[stop] <=max(Table[stop])))

  • srinivas258's avatar
    srinivas258
    Helper I
    6 years ago

    Thanks amitchandak. i tried this and its working CALCULATE(SUM(Table[Total]),filter(allselected(Table),Table[stop] <=max(Table[stop])))

     

    but only other problem is if I add an other column (lets say ColumnA) from different table(lets say TableA) it stopped working.

    Can you please guide me how I can add that column and table to above formula.