Hi!
I have the following code. It sums the story points of all issues whose Planned End is before the Sprint End Date. Now, I want to add a new condition: this sum should only be done if the issue fix version is different than the one choosed in the picture.
How to proceed?
Sum(
Filter(
DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
Not IsEmpty([Measures].[Issue story points])
AND
DateCompare([Issue].CurrentMember.Get('Planned End'),[Sprint].CurrentMember.Get('End date')) < 1
),
CASE WHEN
[Measures].[Issues created]>0
THEN
[Measures].[Issue story points]
END
)
The way that worked for me was this:
I have created a measure named Story Points of Unseen Issues
Filter(
DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
Not IsEmpty([Measures].[Issue story points])
AND
DateCompare([Issue].CurrentMember.Get('Planned End'),[Sprint].CurrentMember.Get('End date')) < 1
AND
InStr([Issue].CurrentHierarchyMember.Get('Fix version IDs'), '82048') > 0
),
CASE WHEN
[Measures].[Issues created]>0
THEN
[Measures].[Issue story points]
END
)
And then I have subtracted it from the total story points:
Sum(
Filter(
DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
Not IsEmpty([Measures].[Issue story points])
AND
DateCompare([Issue].CurrentMember.Get('Planned End'),[Sprint].CurrentMember.Get('End date')) < 1
),
CASE WHEN
[Measures].[Issues created]>0
THEN
[Measures].[Issue story points]
END
) - [Measures].[Story Points of Unforseen Issues]
If there is a better way, tell me!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.