FILTER

Description:

This function is used to return the set that results from filtering a specified set based on a search condition.

Syntax:

Filter(Set_Expression, Logical_Expression )

Return Type:

SET

Parameters:

Parameter	Description

Parameter	Description
Set_Expression	It is a valid MDX expression that returns a set.
Logical_Expression	It is a valid MDX logical expression that evaluates to true or false.

Example 1:

SELECT 
    [Measures].[Internet Sales Amount] ON COLUMNS,
    Filter([Product].[Product].[Product].Members, [Measures].[Internet Sales Amount] > 100000) ON ROWS
FROM [AdventureWorksMF_ValueBased]

Example 2:

[Measures].[Internet Order Quanlity] ON COLUMNS,
    Filter(
        [Customer].[Geography].[Customer].Members,
        [Measures].[Internet Order Quanlity] > 10
    ) ON ROWS
FROM [AdventureWorksMF_ValueBased]