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?
Not IsEmpty([Measures].[Issue story points])
DateCompare([Issue].CurrentMember.Get(‘Planned End’),[Sprint].CurrentMember.Get(‘End date’)) < 1
[Measures].[Issue story points]
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
[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
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.
--resetting this dimension to keep other dimensions in context
[Fix Version].CurrentHierarchy.DefaultMember) >0
--keeping full report context
NOT [Measures].[Issues created]>0
Oskars / support@eazyBI.com