Cumulative issue story points for Transition Author

Questions & Answers
4

Hi @riyyappa

In that case, please try the formula below:

Sum(
  Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    [Measures].[Issue Story Points] > 0
    AND
    ([Measures].[Transitions to status],
    [Transition Status].[Validation]) > 0
  ), ([Measures].[Story Points closed],[Transition Author].DefaultMember)
)

It sums all the closed story points for issues that were transitioned to the status “Validation” by the Transition Author member. If the issue has been transitioned to the status “Validation” several times by different users, the number of story points may show up several times. In that case, further tweaking may be required to get only the time and author of the last transition.

Best,
Roberts // eazyBI support