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
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])