CloseRate calculated by count of Assignees

[Charles_Boden]

Hello,

I’m looking for a way to calculate the number of assignees that have closed tickets in a time frame to use in a calculated member formula.

([Measures].[Issues resolved] / 5) / COUNT OF ASSIGNEES

I can’t seem to find something that works.

Any suggestions would be great

This is the table i’m trying to build.

[gerda.grantina]

Hi @Charles_Boden ,
Here is an answer to a similar question that you may find useful:

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( Descenda…

best,
Gerda // support@eazybi.com