DECILE

Description:

This function is used to return a scalar value signifying decile of the given set.

Syntax:

Decile(Set_Expression, Measure, Numeric Value, Inclusive/Exclusive flag)

Return Type:

SCALAR

Parameters:

Parameter	Description

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 of (0,10]
Inclusive / Exclusive flag	It is a flag specifying Inclusive or Exclusive implementation of percentile. The valid values are Inclusive / Exclusive. Inclusive: Specifies the value at or below which the given percentage of values may be found in distribution. Exclusive: Specifies the value below which the given percentage of values may be found in distribution.

Example:

WITH MEMBER [Measures].[Sales Decile] AS
    Decile([Measures].[Internet Sales Amount])
SELECT 
    {[Measures].[Internet Sales Amount], [Measures].[Sales Decile]} ON COLUMNS,
    [Product].[Product].Members ON ROWS
FROM [AdventureWorksMF_ValueBased]