Total assignee count over time?

Hi @sjoquist.carl,

Using Count() and iterating through “Assignee” dimension members is the right approach. Ther are few improvements you should add to make the calculation work, add the function Filter() and some predefined measure as filtering criteria. The measure would define how how issues (and their assignees) are related to the Time dimension.

For example, to get the assignee count of resolved issues in the period, use the measure “Issues resolved”:

NonZero(Count(
  Filter(
    DescendantsSet([Assignee].CurrentMember,[Assignee].[User]),
    --related to time dimension by issue resolution date
    [Measures].[Issues resolved] > 0
  )
))

Or you can filter by the measure “Issues history” to get a count of all assignees that were assigned to some issue in that period:

NonZero(Count(
  Filter(
    DescendantsSet([Assignee].CurrentMember,[Assignee].[User]),
    --related to time dimension by issue resolution date
    [Measures].[Issues history] > 0
  )
))

Here are a few more topics on how to count assignees:

Best,
Zane/ support@eazyBI.com