FILTER
This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here. |
|---|
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 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]