Forum Discussion
Solved
Problems with formula for creating cumulative counts for a Task Burn-Up Chart
This appears to be a common question within this board and elsewhere on the internet...but having reviewed multiple posts, I'm still unable to do a calculation for cummulative task values for use in ...
Found the solution....
Cummulative Planned Finished Task Count = CALCULATE(sum('Project Schedule Burn-Up Weekly Count'[Weekly Planned Finish Task Count]), FILTER (ALLSELECTED('Project Schedule Burn-Up Weekly Count'[Period Week End]),'Project Schedule Burn-Up Weekly Count'[Period Week End] <= MAX('Project Schedule Burn-Up Weekly Count'[Period Week End])))
Found the solution....
Cummulative Planned Finished Task Count = CALCULATE(sum('Project Schedule Burn-Up Weekly Count'[Weekly Planned Finish Task Count]), FILTER (ALLSELECTED('Project Schedule Burn-Up Weekly Count'[Period Week End]),'Project Schedule Burn-Up Weekly Count'[Period Week End] <= MAX('Project Schedule Burn-Up Weekly Count'[Period Week End])))