Get average of closed issues per week

Hi @Yaron_Moon

You can define a new calculated measure “Assignee counter” in the Measures dimension that will iterate through the Assignee list and count the number of Assignees that had an issue assigned to them during the corresponding week in rows.

The formula would be along these lines:

Count(
  Filter(
    DescendantsSet([Assignee].CurrentMember,[Assignee].[User]),
    (
      [Measures].[Transitions to assignee],
      [Assignee].CurrentMember
    ) > 0
  )
)

You can then define a new calculated measure that would divide the two measures:

[Measures].[Issues closed]
/
[Measures].[Assignee counter]

Let me know if this fits your use case!

Best regards,
Nauris / eazyBI support