Intersection of measures

Hi

We are evaluating eazy BI for our JIRA setup. We would like to have a custom measure that picks up intersection of “Sprint issues committed” and “Sprint issues removed” measures. We are using following formula. But it is yielding empty result.

Sum(
Intersect(
[Measures].[Sprint issues added],
[Measures].[Sprint issues at closing]
)
)

Can you help us with this issue.

Thanks
Bhavin

Hi @Bhavin_Kamani,

When applying set functions like Intersect() or aggregate functions over some set of data you might want to provide the set of data for those functions. In your cases, set of Issues that were committed and then removed from the sprint.

The calculation might look like this:

NonZero(Count(
  Filter(
    --filter a set of issues
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    --for each issue validate if it was committed and then removed from Sprint
    [Measures].[Sprint issues committed] > 0 AND
    [Measures].[Sprint issues removed] > 0 )
))

Check out also related community topics on sprint scope analyses:

You might find interesting also report on sprint issue balance in Demo account:
https://eazybi.com/accounts/1000/cubes/Issues/reports/243468-sprint-issue-balance

Best,
Zane / support@eazyBI.com