Skip to main content
Version: I2023.3.0

MEMBER_LEVEL_NUMBER

The distance of the member from the root of the hierarchy. The root level is the ALL level and has a LEVEL_NUMBER of zero.

Syntax​

Member_Expression.MEMBER_LEVEL_NUMBER

Input Parameters​

N/A

Return Value​

Integer

Example​

Don't display sales amount at the Year level, however display sales amount at all other levels.

IIF([Order Date Dimension].[Order Retail445].currentMember.LEVEL_NUMBER = 1, NULL, [Measures].[salesamount1])