Eazybi instance sharing - How to use mdx to count the number of people working for the project

本文介绍了如何在Eazybi实例中利用MDX语句计算项目中工作的人员数量。通过创建一个新的度量值designeecount,利用当前成员函数、IIF函数、NonZero函数、Count函数和ChildrenSet等MDX表达式,当指派者位于汇总列时,显示员工人数。文章详细解释了MDX中的各个函数用法,并提到了特殊情况的处理方式。
摘要由CSDN通过智能技术生成

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值