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.
Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.
Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.