Sum unique values

Hi.
i have the following measure:

Sum(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Sprint issues completed] > 0
),
[Measures].[Sprint Story Points committed]
)

I want to aggregate the results for several sprints, but i am getting the wrong number. I am getting 70 while the number i want to get is (12+10+19+15)
image

From what i understand, if an issue was committed for in several sprints, the result will take the Story Points committed on each of those sprints. What i am expecting it to do, is to take the committed only in the sprint where the issue was completed.

Can you suggest how can i adjust the measure to achieve that?

Hi @meravbe ,
Thanks for posting your question!

The current formula may not give you the expected results because it’s summing committed story points for completed issues. When you look at the sprint’s indivudally - some of the issues might have been skipped, because they were not completed in the particular sprint.

Instead of using a custom calculation, I’d recommend using the built-in measure Sprint Story Points completed of committed. This measure specifically tracks story points from issues that were:

  • Committed when the sprint started
  • Completed when the sprint closed

This will give you a more accurate count of story points actually completed within each sprint.

The measure is designed to handle cases where issues roll over between sprints, only counting the points in the sprint where they were both committed and completed.

See Jira Software custom fields documentation
Best wishes,

Elita from support@eazybi.com