DistinctNative

Returns a set, removing duplicate tuples from a specified set. Eliminates duplicates based on the element name except consolidated elements in different hierarchies.

Example

DistinctNative( {
  [REGIONS].[World].[Europe].[Central Europe].[Germany],
  [REGIONS].[European Union].[Germany],
  [REGIONS].[Europe (East/West)].[Western Europe].[Germany]
} )

The result is a new set with the first occurrence of Germany in the source set.

{[REGIONS].[World].[Europe].[Central Europe].[Germany]}