Import issue links as dimension

Tips & Tricks
,
18

Hi @Osvalda
Glad to hear that you found this article useful.
If you want to count how many issues are linked to stories, check this eazyBI training account for example measures: Stories with Bugs details - Issues - eazyBI Demo Training - eazyBI

The measure “Linked Bugs count” is the one you are looking for. Copy it and then adjust it and replace dimension name “Bugs” to the issue link dimension you have in your account:

-- annotations.group = 4 Issue links and hierarchies
Case 
When
  [Issue].CurrentMember.Level.Name = "Issue"
  AND
  [Bugs].Currentmember is [Bugs].Defaultmember
Then
  -- retrieve Bugs information from Issue property Bugs
  Nonzero(Count(
    [Issue].CurrentHierarchy.GetLinkedmembers('Bugs')
  ))
Else
 -- total calculation for any issue, data on Bugs level
  NonZero(Sum(
    Descendants([Bugs].Currentmember, [Bugs].[Bugs]),
    -- counts how many times Bugs are reference with issues, this works as a filter as well
    [Measures].[Issues created]
 ))
End

best,
Gerda

1 Like