Released/Unreleased fix version

Questions & Answers
, ,
1

I am trying to create two calculated member, that returns the number of released/unreleased fix version for each project, I have tried something similar to this but it’s not working:

NonZero(
  Count(
    Filter(
      Descendants([Project].CurrentHierarchyMember, [Project].[Project]),
      [Fix Version].CurrentHierarchyMember.Get("Status") = "Unreleased"
    )
  )
)
2

Hi @Sara

​Thanks for your question!

I recommend iterating through the Fix Version dimension by status to count the Fix versions. See the example of the formula below:

Count(
  Descendants([Fix Version.By status].CurrentMember,
  [Fix Version.By status].[Version])
)

​
​You could add the Fix Version dimension in Rows and select the “Status” level. When you expand the Fix versions in the report, you will see the Projects. The formula below will return the count of the Fix versions split by Released/Unreleased
​
​

600×509 56.5 KB

​
​Best wishes,

Elita from support@eazybi.com