Bug Report with 2 Labels -> Count twice

hyunsu.kang · November 3, 2025, 12:19am

I’m trying to generate a bug report using the following jql target issues:

type = Bug AND labels IN (1.9-Prod, 1.9PROD_QA) AND status != Done AND priority != Lowest

Because there are two labels, issues with both labels are counted twice. (Even if I use Aggregate, they’re counted twice.)
To prevent duplicate counts, I used the following member formula.

Count(
  Filter(
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    (
      [Measures].[Issues due],
      [Label].[1.9PROD_QA]
    ) > 0
    OR
    (
      [Measures].[Issues due],
      [Label].[1.9-Prod]
    ) > 0
  )
)

However, this method requires a lot of computation, so it takes over a minute to load and doesn’t display properly.

How can I display it properly?

Please help me out!

[Bug Report Example]