Measure to count number of subtasks of specific issue type per parent issue

Hi @bar368,

The calculated measure “Dependency Subtask” looks for issues with type Dependency Subtask and that also has some subtasks under it. As Dependency subtasks are sub-tasks themselves and can not have any other sub-tasks, the calculated measure returns no data.

To make this work, you might want to use the Sub-task hierarchy in the Issue dimension. And then you may use measure Issues create for the calculation to represent subtasks with a particular issue type. When using a hierarchy, measure values are automatically aggregated from lower hierarchy levels. In this case, the measure “Issues created” would show one for the issue itself plus count of sub-tasks under it.

The calculation might look like this:

([Measures].[Issues created],
[Issue Type].[Dependency Subtask])

The report might look like in the picture below:

Best,
Zane / support@eazyBI.com