Count

Returns the number of tuples in a set.

Empty cells are included unless the ExcludeEmpty optional flag is used.

Syntax

Count(Set_Expression [,( ExcludeEmpty | IncludeEmpty )])

or

Set_Expression.Count

Arguments

Set_Expression	MDX expression that returns set.
ExcludeEmpty	Empty cells are included unless this optional flag is used.

Examples

Count of version child members in the "Fix Version" dimension

This formula counts the immediate child members of the current "Fix Version" dimension member. This formula can be used in reports or calculations to determine how many versions are in each status for each project.

[Fix Version].CurrentHierarchyMember.Children.Count

Count of assignees who have assigned issues

This formula counts how many assignees have at least one issue created and assigned to them. It filters out any assignees who have no issues assigned (i.e., where the number of issues created is zero or less) and then counts the remaining assignees.

Count(
  Filter( 
    [Assignee].[User].Members,
    [Measures].[Issues created] > 0
  )
)

Count of completed Sprints

This MDX formula counts the number of completed Sprints that have at least one issue created.

NonZero(
Count(
  Filter(
    Descendants([Sprint].CurrentMember, [Sprint].[Sprint]),
    [Sprint].CurrentMember.GetBoolean("Closed")
    AND
    [Measures].[Issues created]>0
  )
))

Count of versions released in a period

This formula counts how many versions were released in the selected time period, excluding unreleased versions, and only considering versions that have at least one issue created for them:

NonZero(
  Count(
    Filter(
      Descendants([Fix Version].CurrentMember, [Fix Version].[Version]), 
      DateInPeriod(
        [Measures].[Version release date], 
        [Time].CurrentHierarchyMember
      )
      AND
      [Fix Version].CurrentMember.Get("Status") <> "Unreleased" 
      AND
      (
        [Measures].[Issues created], 
        [Time].CurrentHierarchy.DefaultMember
      ) > 0 
    )
  )
)

See the example report Versions with release date in period in our Demo account. The calculated measure Versions released in period uses the formula above. It counts fix versions with release date in a selected period and if the status currently is not unreleased. The report has another similar measure Unreleased versions in period counting versions in period that are unreleased currently.