Forum Discussion

Midhunc22's avatar
Midhunc22
Regular Visitor
3 years ago

Running Total based on Dimension level

Hello,      I am trying to get the Running total based on ServiceID But getting an error. Below is my table data . I Group     Service ID     Amount    A               1                $2    A   ...
Tips and Tricks
ryan_mayu's avatar
ryan_mayu
Super User
3 years ago

Midhunc22 

why you want to create rank column?

is this what you want?

running total = sumx(FILTER('Table','Table'[Group]=EARLIER('Table'[Group])&&'Table'[Service ID]<=EARLIER('Table'[Service ID])),'Table'[Amount])

  • Midhunc22's avatar
    Midhunc22
    Regular Visitor
    3 years ago

    Hi ryan_mayu  ,

        I have tried this DAX as well. but Earlier function does not getting any columns its giving an error as Earlier row context which does not exist .

     

    running total = sumx(FILTER(Sampledata,Sampledata[Group]=EARLIER(group)&&Sampledata[ Service ID ]<=EARLIER(Service)),Sampledata[Amount])

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      3 years ago

      Midhunc22 

      pls try this

       

      running total = sumx(FILTER(Sampledata,Sampledata[Group]=EARLIER(Sampledata[Group])&&Sampledata[ Service ID ]<=EARLIER(Sampledata[ Service ID ])),Sampledata[Amount])