Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
Regards,
Tom
Hey @xRTP .
deleted the leading bracket in line 8.
Regards,
Tom
Hello, the error was removed and new error exist lol why im getting this error on visual
Here is the code
Hey @xRTP ,
hit see details and provide the information.
Regards,
Tom
Hey @xRTP ,
replace the curly brace in line 7 and 9 with square bracket.
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |