I would like to create an user-defined measure for eazyBI that gives the sum of the story points of all issues whose Planned End Date is before the Sprint End Date. I want this to only be done in the current sprint.
This is what I tried. Not working,
Sum(
Tail(Filter(
[Measures].[Story Points created],
[Sprint].CurrentMember.Get('Status') = "Active"
AND
DateCompare([Issue].CurrentMember.Get('Planned End Date'),[Sprint].CurrentMember.Get('End Date')) < 1
)
))