Sum of story points in a status grouped by version

Questions & Answers
1

Hello,
I’m building a fix version report to get how many story points came from issues in a certain status in that fix version.
I have the “story points closed” measure, but I have 3 closed statuses, so I’d need something more.
The measure I need is the number of story points from issues in a ‘Deployed’ status, so that I can use that measure with versions as a dimension to get how many story points were deployed.
Is there a quick way to get it?
thanks

2

Hi @Mauro_Bennici,

Try the formula below:

Sum(
  Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    Not IsEmpty([Issue].CurrentHierarchyMember.Get('Story Points'))
    AND
    ([Measures].[Transitions to status],
    [Transition Status].[In Review]) > 0
  ),[Measures].[Story Points created]
)

It iterates through all issues that have story points and transitioned to the status In Review. In the end, sums the Story Points for those issues.

The report then could look similar to the one below:

Screen Shot 2020-09-25 at 11.41.19
Screen Shot 2020-09-25 at 11.41.19799×570 51.9 KB

Visit the eazyBI documentation page for more information on Descendants() function - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/descendants.

Best,
Roberts // support@eazybi.com