IsLevel

Returns TRUE if the member is in a specified level.

Syntax

IsLevel ( member , index )

Parameter	Description
member	A member specification.
index	A level number.

Example

IsLevel([Market].CurrentMember, 1)

returns TRUE if the current member of the Market dimension is at level 1.

Therefore, the following query

SELECT
 Filter([Market].Members, IsLevel([Market].CurrentMember, 1))
ON COLUMNS
FROM Sample.Basic

returns

East	West	South	Central
24161	29861	13238	38262