How to count all Projects including Projects with no Issues?

Questions & Answers
, ,
1

I wanna ask you for a formula to count all projects, including projects without issue.

I have tried this formula :
SUM(
[Project].[Project].Members,
CASE WHEN
[Measures].[Issues created] >= 0
THEN
1
END
)

But it doesn’t work.

Really need your help on this.

Thanks

2

Hi @sinchan_3188

Try this formula below. It should count children of the hierarchy level regardless of the count of issues

Sum(
Childrenset([Project].CurrenthierarchyMember),
1
)

Martins / eazyBI support