Getting a count of issues that do not have a given link

Questions & Answers
2

Hi @Skye,

I recommend defining a calculated measure that determines the Issue dimension current level in such a case. In the “Issue” level, it should return the measure “Issues created” when it is not linked. At a “Project” or “All” level, it should sum up all the issues without the link. The formula could look similar to the one below:

CASE WHEN [Issue].CurrentHierarchyMember.Level.Name = "Issue"
THEN
  NonZero(IIf(
    IsEmpty([Issue].CurrentHierarchyMember.Get('Caused Bugs')),
    val([Measures].[Issues created]),NULL
  ))
ELSE
  Sum(
    Filter(
      Descendants([Issue].CurrentMember,[Issue].[Issue]),
      IsEmpty([Issue].CurrentHierarchyMember.Get('Caused Bugs'))
    ),
    [Measures].[Issues created]
  )
END

I used the issue link “Caused Bugs”. Update the formula to fit your use case. After that, the report could look similar to the one below:

Screenshot 2022-06-16 at 14.39.48
Screenshot 2022-06-16 at 14.39.482474×1236 194 KB

I also recommend using the “Drill into measure by another dimension” functionality to have only the relevant measures distributed across columns - Create reports.

Best,
Roberts // support@eazybi.com

1 Like