| title | IsLeaf (MDX) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/02/2016 | |
| ms.prod | analysis-services | |
| ms.prod_service | analysis-services | |
| ms.service | ||
| ms.component | ||
| ms.reviewer | ||
| ms.suite | pro-bi | |
| ms.technology | ||
| ms.tgt_pltfrm | ||
| ms.topic | language-reference | |
| f1_keywords |
|
|
| dev_langs |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | 54862bb3-acc2-4711-ac5a-faa9e9de3721 | |
| caps.latest.revision | 30 | |
| author | Minewiskan | |
| ms.author | owend | |
| manager | erikre | |
| ms.workload | Inactive |
[!INCLUDEssas-appliesto-sqlas]
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]