GETFILTERINFO
Description:
This function is used to return the set of tuples on a specified axis of the sub-select.
Syntax:
GetFilterInfo(Hierarchy_Expression)
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Hierarchy_Expression | It is a valid MDX expression that returns a hierarchy. |
Example:
with member
[Measures].[FilterCount] as
Count(GetFilterInfo([Customer].[Geography]))
select
[Measures].[FilterCount] on columns,
GetFilterInfo([Customer].[Geography]) on rows
from
(SELECT FILTER([Customer].[Geography].[Country],([Measures].[Sales Amount]> 5000000)) ON COLUMNS FROM [AdventureWorksMF_latest] )