Intersection of measures

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