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:
SELECT
[Measures].[Internet Sales Amount] ON COLUMNS,
Distinct({[Date].[Calendar].[Calendar Year].&[2012]} * {[Product].[Product Categories].[Category].&[Bikes]}) ON
ROWS
FROM [AdventureWorksMF_ValueBased]