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