Get issues that have two labels (both labels)

Questions & Answers
,
2

Hi @nikbats

A label is a multi-value field in Jira and eazyBI imports it in a separate dimension.
That means there could be different scenarios how issue can have labels (no labels, one label, multiple-labels) which can complicate the query.

One way to create such counter would be using descendants function which goes through issues and checks if issue belongs to the both labels.

NonZero(
  sum(
    Filter(
      Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
      CoalesceEmpty([Measures].[Issue labels], "") MATCHES ".*Label-1.*"
      AND
      CoalesceEmpty([Measures].[Issue labels], "") MATCHES ".*Label-2.*"
  ),
  [Measures].[Issues created count]
))

But that is a quite iterative approach and it requires “Nonempty” cross join in report rows to be enabled as the calculation would go through “Issue” dimension all members to filter the right set for the calculation in each table cell. Thus it could be slow if you use this measure with many other report filters especially if multiple-values are filtered in some page dimension.

If you could tell us more about the context of your report (what other dimensions will be used in the report rows, pages, columns) we could point some directions on how to optimize the calculation steps by adding additional validations to reduce the set for the calculation.

Martins / eazyBI support