Which filter shows a member and all its descendants in a view?

• A. TreeDescendants
• B. TreeDescendantsInclusive
• C. Descendants
• D. Ancestors

Answer: (B)

To show a member along with every level beneath it in a view, you need the filter that includes the member itself and all its descendants. The inclusive version of the descendants filter does exactly that: it returns the selected member plus all of its child members, grandchildren, and so on.

Other filters serve different purposes. The non-inclusive descendants filter returns only the descendants, not the member itself, so the selected member wouldn’t appear. A plain descendants filter or an ancestors filter doesn’t display the subtree you’re after—ancestors shows the path upward, not downward through the tree.

For example, if you pick a member "Region A" with children Region A1 and Region A2, the inclusive descendants filter would show Region A, Region A1, and Region A2, whereas non-inclusive descendants would show Region A1 and Region A2 only. That’s why the inclusive option is the best match for showing a member and all its descendants.