Linked bug count against Assignee in the past

Questions & Answers
1

Hello Team,

I have below issue property and I want to count all the linked bug to the issues which was having assignee in the past.

image
image706×259 4.2 KB

I want something in below design:

image
image699×157 4.41 KB

@zane.baranovska @Marcelo_Ignacio_Cid1 @gerda.grantina @lauma.cirule

2

Hi @Deepak ,
You can use this formula to get linked issues that were assigned to the assignee

sum(
  Filter(
    Descendants([Linked issues].Currentmember, [Linked issues].[Linked issues]),
      DefaultContext((
        [Issue].[Issue].GetMemberByKey(
            [Linked issues].CurrentMember.key),
        [Measures].[Transitions to assignee],
        [Assignee].CurrentHierarchyMember))>0
  ),
  CASE WHEN
    ([Measures].[Transitions to assignee],
    [Assignee].CurrentHierarchy.DefaultMember)>0
  THEN
    1
  END
)

And this is to count issues that were assigned:

NonZero(
  Count(
    Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Transitions to assignee]>0)
  )
)

In the report, it would look like this:

image
image1000×938 69.1 KB

Kind regards,
Gerda // support@eazybi.com

3 
Thank you for the solution.
One more thing I am using below code to count issues on different condition but I am not able to use issue label propery. When i select this it shows empty , could you please help here 
NonZero(Count(
  Filter(Descendants([Issue].[Issue].Hierarchy),
    
    
    (
        ([Measures].[Transitions to issues count],[Issue Type].[Story or CR],[Transition].[Dev to QA])>0
    
     OR   
        ([Measures].[Transitions to status issues count],[Transition Status].[Done],[Issue Type].[Spike])>0

    OR 
      ([Measures].[Transitions to status issues count],[Issue Type].[Story or CR],[Transition].[Dev to QA],[Label].[LeanConvert])>0
        )
      )
    ))
4

@gerda.grantina is there any help you can provide on above query?