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 lowest under # Errors column

 

Note: All 3 columns are just 1 column, 1st column is Test, 2nd column is count of Test and third is the Cumulative of Test.

Appreciate your answers!

 

Need Help
Show and Tell

7 Replies

  • 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

      • TomMartens's avatar
        TomMartens
        Super User
        4 years ago

        Hey Anonymous .

         

        deleted the leading bracket in line 8.

        Regards,
        Tom