Create Measure using Filter by Fix Version

[Gabriel Alves Coelho]

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

)

[Gabriel Alves Coelho · Accepted solution]

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!