IsLeaf (MDX)

 

Updated: March 2, 2016

Returns whether a specified member is a leaf member.

  
IsLeaf(Member_Expression)   

Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.

The IsLeaf function returns true if the specified member is a leaf member. Otherwise, the function returns false.

The following example returns TRUE if [Date].[Fiscal].CurrentMember is a leaf member:

WITH MEMBER MEASURES.ISLEAFDEMO AS

IsLeaf([Date].[Fiscal].CURRENTMEMBER)

SELECT {MEASURES.ISLEAFDEMO} ON 0,

[Date].[Fiscal].MEMBERS ON 1

FROM [Adventure Works]

MDX Function Reference (MDX)

Community Additions

ADD
Show: