fbpx

Distinct (MDX)

Returns a set removing all duplicated members.

Parameters

Name Type Cardinality Default value
  set-expression     

Return

numeric-value

Description

Returns a set removing duplicated members from the parameter set.

{A,B,A,C,A} -> {A,B,C}

This function keeps the order of the original set.

See Also

Count DistinctCount

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.