| title | IsLeaf (MDX) | Microsoft Docs |
|---|---|
| ms.date | 06/04/2018 |
| ms.prod | sql |
| ms.technology | analysis-services |
| ms.custom | mdx |
| ms.topic | reference |
| ms.author | owend |
| ms.reviewer | owend |
| author | minewiskan |
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]