ISLEAF

This formula returns 1 if a specified element is a base element of a hierarchy, or 0 if it is not a base element.

Syntax

=MDX.GET(Database Alias, Cube, "IsLeaf("&"Element unique name"&")")

Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.