Calculated Measure for Issue Links Count

[zane.baranovska]

Hi @Bob,

Your calculation counts issues that have linked bugs but not the bugs. You can slightly adjust the calculation and use the dimension “Related Bugs”, not the “Issue” dimension,

Count(
  Filter(
    --iterate through Related Bugs members
    Descendants([Related Bugs].CurrentMember, [Related Bugs].[Related Bugs]),
    [Measures].[Transitions to status issues count] > 0
  )
)

Please make sure to import the “Related Bugs” as both – property and dimension to make this work.

There is an alternative option if you have the “Issue” dimension on report rows showing each story. In that case, you can create a calculated measure that would count how many commas you have in the list of linked bugs for each story. See this Community post for more details:

Question: Counting the Number of Linked Issues

Hi, @jlayug! There are several ways how to look at this: First and most straightforward approach would be to count how many keys are in the Issue property. The following formula would do this by counting how many commas are in the string of bugs linked to the issue. CASE WHEN NOT IsEmpty([Issue].CurrentMember.get('Bugs')) THEN Len([Issue].CurrentMember.get('Bugs')) - Len(Replace([Issue].CurrentMember.get('Bugs'), ',', '')) + 1 END Second way would be to count linked issues by getting …

Best,
Zane / support@eazyBI.com