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!
Hey @xRTP ,
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.
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!