Get Count of Issues With a Certain Sub-task Type

Questions & Answers
1

Hello community!

I have been trying to get quite a specific measure lately, and I feel like I need some help here.

We created a sub-task type called “Automation Sub-task”. And we would like to measure how many issues have this sub-task (regardless of it having 1 or “x” amount of it).

At the moment I have this:
Sum(
Filter(
Descendants(
[Issue].CurrentMember, [Issue].[Issue]),
NOT IsEmpty([Issue].CurrentHierarchyMember.get(‘Sub-task keys’))
),
[Measures].[Issues resolved]
)

This is currently pulling all the issues that have any sub-task. I just don’t know how to make a measure that only returns the parent issues that have any amount of “Automation Sub-task”

Hopefully someone here knows the answer.

Thanks!

Lucas

2

Hi,

This formula is on the right track. For a full solution, we can use the Parent level of the sub-task hierarchy and filter if a parent has a sub-task of a specific issue type.

NonZero(Count(
  Filter(Descendants([Issue.Sub-task].CurrentHierarchyMember,
    [Issue.Sub-task].[Parent]),
    --parent is resolved
    ([Measures].[Issues resolved])>0 
    AND
    -- parent has children of specific type , including unresolved
    ([Measures].[Issues created],
    [Issue Type].[Automation Sub-task])>0
    )
))

Kindly,
Janis, eazyBI support

1 Like