Story Points Burndown for specific status

Hi Lars,

Thank you for the feedback and sorry for the delayed answer.

There is a standard measure “Story points history” which you can combine with the Transition status dimension and show the number of the story points transitioned to the status selected. It is a cumulative measure showing the status at the end of the period. For instance, when you will use this measure in the sprint burndown report with the “Done” status, it will be similar to the Cumulative story points resolved measure in the sprint burndown report.

A more precise measure of the story points transitioned could be created with calculation like this (“Story points transitioned”):

sum(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Transitions to status]>0
  ),
  ([Measures].[Story Points created],
   [Time].CurrentHierarchy.DefaultMember,
   [Transition Status].DefaultMember)
)

This measure, when used in the report with the Transition Status dimension will count the number of story points transitioned to the selected status and you can build a cumulative measure on it with similar formula Cumulative Story points resolved (replace the Story points resolved measure with the “Story points transitioned”).

Please, keep in mind that using the “Story points history” measure with the Transition Status dimension limits the measure to the selected status. Probably, the Story points remaining measure would need the following adjustment:

([Measures].[Story Points history],
 [Transition Status].DefaultMember) 
-
[Measures].[Cumulative story points transitioned]

The sprint dimension in the burndown reports is utilized for the trend and guideline calculations since those have any meaning when the start and end dates are defined for the sprint scope. The dates can be replaced by custom dates stored as constants in a custom calculated measures and the calculations rewritten to get the dates from the measures, but you will also need to define the scope of the burndown.

Kindly,
Janis, eazyBI support