All eazyBI for Jira eazyBI for Confluence Private eazyBI

Distinct

Returns a set, removing duplicate tuples from a specified set.

Syntax

Distinct(Set1_Expression, Set2_Expression)

Arguments

Set_Expression

MDX expression that returns set.

Examples

Both examples below use a calculated member "Bugs & stories" from the "Issue type" dimension. It aggregates two issue types together for calculations.

Aggregate({
[Issue Type].[Bug],
[Issue Type].[Story]
})


This example is a calculated measure with Distinct function to sum the issues created for distinct set issue types from two members in Issue type dimensions. Tickets with the Bug type would be counted just once in the results.

Sum(
  Distinct({
    CascadingChildrenSet([Issue Type].[Bugs & stories]),
    [Issue Type].[Bug]
  }),
  [Measures].[Issues created]
)

See also