Is

Returns TRUE if two members are identical.

Syntax

IS ( member1 , member2 )

member1 IS member2

Example

IS([Year].CurrentMember.Parent, [Qtr1]) 

returns TRUE if the parent of the current member in [Year] dimension is [Qtr1].

Filter([Year].Levels(0).members, IS([Year].CurrentMember.Parent, [Qtr1]))

returns children of [Qtr1].

The following query returns all members of [Market] that have the parent [East]; in other words, children of [East].

SELECT 
{ 
  Filter (
    [Market].members,
    [Market].CurrentMember.Parent IS [East]
  ) 
}
on columns
FROM sample.basic

This query returns the following grid: