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)