Create calculated member in the dimension to get the count of next hierarchy level

Questions & Answers
,
1

Hi,

I am new to easyBI and still exploring.

I am trying to write a calculated field in a profiled dimension. Basically, I need to get the count of total number of its next hierarchy level.

Eg. Profiled Hierarchy : Org -> Services -> Service Requests

I want to display the count of Services under each Org, count of service request in each service by quarter.

Can anyone please suggest some tips on how to do this?

Thanks.

2

Hi Ramya,

This is Lauma and we resolved this issue also through support@eazybi.com

As a summary here - you can create a calculated measure that counts Projects with issues created using following formula

Count(
  Filter(
  Descendants([Project].CurrentMember, 
    [Project].[Project]),
  [Measures].[Issues created] > 0
  )
)

For each Profield Org it would show the active Project count. And another formula that counts how many Profield services there are

Count(
  Filter(
  Descendants([Profields Services].CurrentMember, 
    [Profields Services].[Profields Services]),
  [Measures].[Issues created] > 0
  )
)

Kind regards,
Lauma / support@eazybi.com