Document toolboxDocument toolbox

Percentile

Owned by Elvis Kvalbergs
Last updated: Aug 03, 2022 by Gvido
1 min read

Returns the value of the tuple that is at a given percentile of a set.

Syntax

Percentile( Set_Expression , Numeric_Expression , Numeric_Expression )

Arguments

Set_Expression

MDX expression that returns a set.

Numeric_Expression

MDX expression that returns a number.

Numeric_Expression

MDX expression that returns a number representing a percentile

Examples

The following example calculates 75 percentile of resolution days for resolved issues in period:

Percentile(Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    DateInPeriod(
      [Issue].CurrentHierarchyMember.Get('Resolved at'),
      [Time].CurrentHierarchyMember)
    AND [Measures].[Issues resolved] > 0),
  [Measures].[Total resolution days],
  75
)