Parent issues committed vs completed

Hi @dave ,

Try defining a new calculated measure that iterates through all committed parent issues and sum the number of the completed ones. See the formula below:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    -- issue doesn't have a parent issue (is not a sub-task)
    IsEmpty([Issue].CurrentHierarchyMember.Get('Parent issue key'))
    AND
    -- was committed to the Sprint
    [Measures].[Sprint issues committed] > 0
  ),[Measures].[Sprint issues completed]
)

The report then could look similar to the one below:

See the eazyBI documentation page for more details on defining calculated measures - Calculated measures and members - eazyBI for Jira.

Best,
Roberts // support@eazybi.com