fbpx

Percentile (MDX+)

Returns the percentile value of the specified set expression

Parameters

Name Type Cardinality Default value
  set-expression  one   
  value-expression  one   
  numeric-expression  one   

Return

value

Description


The percentile function calculates the percentile value of the non-empty values (Wikipedia).

The parameters use a range from 0 to 100.0 where the corresponding value for 50.0 is the median value.

Percentile ( [Countries], [Sales Amount], 50.0 ) ; same as the Median

And it is also equivalent than using a function on a Vector :

Vector( [Countries], [Sales Amount], EXCLUDEEMPTY)->percentile( 50 )

See Also

Median Avg Min Max Sum Vector

Examples

Special Examples (errors, null, ...)

Since Version

6.1

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.