New Assignee Group Calc Member

Questions & Answers
1

Not sure what I’m doing wrong here.

This one does not work. Need to exclude Users that are in either of these 2 groups.

Aggregate(
Except(
[Assignee Group].[Group].Members,
{[Assignee Group].[_Assignee],
[Assignee Group].[_ServiceUsers]}
)
)

This one works. Gives give me only users in either of those 2 groups.
Aggregate({
[Assignee Group].[_Assignee],
[Assignee Group].[_ServiceUsers]}
)

2

Hi,

Assignee group is a multi-value dimension (issues can have several assignee groups), and excepting the groups cannot be done in the aggregated member with the Except function.

The solution is to use the member of the unnecessary groups and subtract from the total in the custom measure. Assuming you have Assignee and Service Users aggregate (“Assignees and Service”), the formula could be the following:

[Measures].[Issues created]-
([Measures].[Issues created],[Assignee Group].[Assignees and Service])

Kindly,
Janis, eazyBI support