Forum Discussion

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 ...

Super User

3 years ago

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