DISTINCT
Description:
This function is used to evaluate a specified set, removes duplicate tuples from the set, and returns the resulting set.
Syntax:
Distinct(Set_Expression)
Return Type:
Set
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Example:
WITH SET MySet AS
{[Customer].[Geography].[Country].&[Australia],[Customer].[Geography].[Country].&[Canada]
}
MEMBER [Measures].[Count] AS
COUNT(MySet)
MEMBER [Measures].[DistinctCount] AS
COUNT(DISTINCT(MySet))
SELECT {[Measures].[Count], [Measures].[DistinctCount]} ON 0,
DISTINCT(MySet) ON 1
FROM [AdventureWorksMF]