LEVEL.COUNT.ELEMENT
This formula returns the number of elements at a specified level of a hierarchy.
Syntax
=MDX.GET(Database Alias, Cube, "Level unique name"&".Members.Count")
Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.
Example
This formula returns 29, the number of elements at the Size level of the Product dimension in the Best Practices sample database:
=MDX.GET("Best Practices OLAP", "ANALYSIS", "[PRODUCT].[Size]"&".Members.Count")