| title | DistinctCount (MDX) | Microsoft Docs |
|---|---|
| ms.date | 06/04/2018 |
| ms.prod | sql |
| ms.technology | analysis-services |
| ms.custom | mdx |
| ms.topic | reference |
| ms.author | owend |
| ms.reviewer | owend |
| author | minewiskan |
Returns the number of distinct, nonempty tuples in a set.
DistinctCount(Set_Expression)
Set_Expression
A valid Multidimensional Expressions (MDX) expression that returns a set.
The DistinctCount function is equivalent to Count(Distinct(Set_Expression), EXCLUDEEMPTY).
The following query shows how to use the DistinctCount function:
WITH SET MySet AS
{[Customer].[Customer Geography].[Country].&[Australia],[Customer].[Customer Geography].[Country].&[Australia],
[Customer].[Customer Geography].[Country].&[Canada],[Customer].[Customer Geography].[Country].&[France],
[Customer].[Customer Geography].[Country].&[United Kingdom],[Customer].[Customer Geography].[Country].&[United Kingdom]}
*
{([Date].[Calendar].[Date].&[20010701],[Measures].[Internet Sales Amount] )}
//Returns the value 3 because Internet Sales Amount is null
//for the UK on the date specified
MEMBER MEASURES.SETDISTINCTCOUNT AS
DISTINCTCOUNT(MySet)
SELECT {MEASURES.SETDISTINCTCOUNT} ON 0
FROM [Adventure Works]