How to exclude a user story workflow such as "de-scoped" for Sprint Story Points at closing

Questions & Answers
1

Hello,

I am struggling to figure out how to make sure the Sprint story points at closing is not taking into account story points from “de-scoped” stories. Currently the Sprint story points at closing formula is taking it all into account.

`-- Story points from issues when a sprint was closed

( [Measures].[Story Points added],
[Transition Field].[Sprint status],
[Sprint Status].[Closed],
[Issue Sprint Status Change].[Active => Closed]
)
`

I tried using various measures but it isn’t working, and it keeps giving me the same result or no results. Would be very grateful if someone could help me out. I’ve tried aggregating, using except transition status method I’ve seen on other forums and none of them seem to be working.

de-scoped

2

I have tried the following and it doesn’t work:

( [Measures].[Story Points added],
[Transition Field].[Sprint status],
[Sprint Status].[Closed],
[Issue Sprint Status Change].[Active => Closed],
[Status].[De-scoped].DefaultMember)
)

Also tried these:

Sum(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Sprint status] = “Closed” AND
[Measures].[Sprint closing] = “Closing” AND
[Measures].[DeScopeStatus] <> “DeScoped”
),
[Measures].[Story Points]
)

3

Hi, @Mufasa

Welcom to the eazyBI community!

It’s nice to see you are trying before asking.

Please consider using a tuple and substraction. Read more about the powerful tool - tuple here: Tuple

From all the Sprint story points at closing remove the ones, with the status “De-Scoped”. The formula should look something like this:

[Measures].[Sprint Story Points at closing]
-
(
[Measures].[Sprint Story Points at closing],
[Transition Status].[De-scoped]
)

Kindly,
Ilze