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
)
Hi @Gabriel_Alves_Coelho,
Welcome to the eazyBI community!
The exclusion of a specific Fix version could be done in several ways depending on your requirement.
If you only want to exclude one specific Fix version that does not change - you might hard-code the specific Fix version ID in the measure expression with an extra condition like
AND
[Issue].CurrentHierarchyMember.Get("Fix version IDs") NOT MATCHES "(.*,|^)<ID of fix version to exclude>(,.*|$)"
I suggest putting this condition in the secondary filter next to [Measures].[Issues created]>0
An alternative version, if you want to exclude dynamically changeable Fix version(s) selected in the page filter, would need the adjustment of the existing second-level condition.
([Measures].[Issues created],
--resetting this dimension to keep other dimensions in context
[Fix Version].CurrentHierarchy.DefaultMember) >0
AND
--keeping full report context
NOT [Measures].[Issues created]>0
Regards,
Oskars / support@eazyBI.com