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:
New York | Massachusetts | Florida | Connecticut | New Hampshire |
---|---|---|---|---|
8202 | 6712 | 5029 | 3093 | 1125 |