Forum Discussion
Cumulative total filtered by subcategory
Hi All,
I feel like this should be simple but just can't figure out the right approach. I have calculated a running total per rank (not using dates but sprints in an Agile project) successfully. However I would now like to calculate the running total for completed or "Done" i.e. by status.
I think for step one I need to calculate the total points per Sprint filtered by "Done" status as a calculated column probably using the calculate function. I have tried the following from other forums:
Column = CALCULATE(
SUM(
'Story List'[ONLY work point]),
ALLEXCEPT('Story List','Story List'[Sprint]),
FILTER('Story List','Story List'[Status] = "Done"))
However as you can see whilst I have successfully split the total points into sprints, I cannot split further by a "Done" Status.
| Points | Sprint | Sprint total WPs | Completed points |
| 4.7 | 0 | 994.45 | 628 |
| 4 | 0 | 994.45 | 628 |
| 2.7 | 0 | 994.45 | 628 |
| 1.35 | 0 | 994.45 | 628 |
| 5.4 | 1 | 9.5 | 628 |
| 3.1 | 1 | 9.5 | 628 |
| 1 | 1 | 9.5 | 628 |
| 3.4 | 2 | 12.4 | 628 |
| 2 | 12.4 | 628 | |
| 4 | 2 | 12.4 | 628 |
| 4 | 2 | 12.4 | 628 |
| 1 | 2 | 12.4 | 628 |
| 3 | 4.7 | 628 | |
| 1 | 3 | 4.7 | 628 |
| 0.5 | 3 | 4.7 |
Would love some help!
thanks
1 Reply
- lbendlin
Super User
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.
