Get the sum of all sprints of a calculated member

Questions & Answers
1

Hi to everyone

I have created a calculated measure that includes all the sprints of a year, but I need to get all the number of sprints under this calculated member, when I try to get this number I get the issues created under the sprints, here is my formula:

Nonzero(sum(
Filter([Sprint].CurrentHierarchyMember,
Not iseampty([Sprint].CurrentHierarchyMember.Name)),
[Sprint].CurrentHierarchyMember))

Could you please help me with this?

2

Hi @PpMoY_LeeGun

Welcome to the community!

Yes, you may create a calculations where you filter sprints by their start date, and then sum up (or calculated the average or another value) different metrics over those sprints. As an example, the following calculations retrieves all completed Story points:

NonZero(SUM(
  Filter(
    Descendants([Sprint].CurrentMember, [Sprint].[Sprint]),
    DateInPeriod(
    [Sprint].CurrentMember.GetDate('Start date'),
    [Time].CurrentHierarchyMember)),
    ([Measures].[Sprint Story Points completed],
     [Time].CurrentHierarchy.DefaultMember)
))

Those metrics should be created in Measures!
When you select TIme dimension Year level members in Rows or in Pages, sprint from the selected year would be retrieved.

You may want to check out a report from Demo account where values ar calculated based on sprints started in selected month: https://eazybi.com/accounts/1000/cubes/Issues/reports/185871-sprint-cycles-by-time

Best,
Ilze / support@eazybi.com

1 Like