Row: assignee group
Column:project
Add a new Measure, designeecount, and enter the following mdx statement
IIF([Assignee].currentmember Is [Assignee].[All Assignees],
NonZero(Count(
Except(
ChildrenSet([Assignee].currentmember),
{ [Assignee].[(unassigned)] }
)
, EXCLUDEEMPTY ) ) ,
IIF(IsEmpty(([Assignee].CurrentMember,[Measures].[Issues created])),
NULL,
1)
)
When the assignee is in the summary column, it displays the number of employees.
First, you need to understand the concept of the dimension’s current member function, that is, the meaning of the current member. Microsoft explains that when traversing a group of hierarchy members, at each step of the traversal process, the operated member is the current member. The CurrentMember function returns the member.
It uses functions
IIF: IIF function takes three parameters: IIF (< condition >, < then Branch >, < else