IsLeaf

Returns TRUE if the member is a level-0 member.

Syntax

IsLeaf ( member )

Notes

IsLeaf(member) is the same as IsLevel(member, 0).

Example

IsLeaf([Market].CurrentMember) 

returns TRUE if the current member of the Market dimension is at level 0.

Therefore, the following query

SELECT
 Filter([Market].Members, IsLeaf([Market].CurrentMember))
ON COLUMNS
FROM Sample.Basic

returns