Creating a custom MDX filter

  1. Create a filter
  2. In the Filter By column, select Custom MDX.
  3. Specify an MDX statement.

Example

This example filters the Product dimension so that only its base elements are displayed. 
isLeaf([Product].CurrentMember)