Cumulative Running Total

[Anonymous]

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!

[TomMartens]

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]

@TomMartens 

Hello im getting this error 

[TomMartens]

Hey @Anonymous .

deleted the leading bracket in line 8.

Regards,
Tom

[Anonymous]

@TomMartens 

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

Here is the code 

[TomMartens]

Hey @Anonymous ,

hit see details and provide the information.

Regards,

Tom

[TomMartens]

Hey @Anonymous ,

replace the curly brace in line 7 and 9 with square bracket.

Regards,

Tom

[Anonymous]

@TomMartens 

Hello, yes already replace the curly braces but still getting no visual as error