PERCENTILE
Description:
This function is used to return a scalar value signifying percentile of the given set.
Syntax:
Percentile(Set_Expression, Measure, Numeric Value, Inclusive/Exclusive flag)
Return type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Measure | It is a valid measure. |
Numeric Value | It is a valid numeric value in the range (0, 100]. |
Inclusive/Exclusive | Inclusive: Specifies the value at or below which the given percentage of values may be found in distribution. |
Example:
Percentile([Geo].[H_Geo].[Country], [Measures].[Sum Sales], 40, Inclusive)