Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Cumulative Running Total

Hello,    I need help on cumulative running total, it adds on acsending order (alphabetical order) base on column test   The thing is i want to add first is the biggest number down to the l...
Need Help
Show and Tell
TomMartens's avatar
TomMartens
Super User
4 years ago

Hey Anonymous ,

 

Try this measure

measure =
var currenterrors = 
calculate( sum( 'yourtable'[# errors] ) )
return
calculate(
sumx(
filter( 'your table'
, 'yourtable'[#errors} >= currenterrors )
)
, 'yourtable'[#errors}
)
, all('yourtable'[test]
)


Hopefully, this provides what you are looking for.
If not provide sample data, and describe the expected result based on the data you provide.

 

Regards,

Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    TomMartens 

    Hello im getting this error 

     

    • TomMartens's avatar
      TomMartens
      Super User
      4 years ago

      Hey Anonymous .

       

      deleted the leading bracket in line 8.

      Regards,
      Tom

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        TomMartens 

        Hello, the error was removed and new error exist lol why im getting this error on visual

        Here is the code