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 |
|---|---|
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:
SELECT [Measures].[Customer Count] ON 0,
FILTER(
[Date].[Calendar].[Date].MEMBERS
, [Measures].[Customer Count]>10)
ON 1
FROM[AdventureWorksMF]