Members (String) (MDX)
Returns a member specified by a string expression.
Syntax
Members(Member_Name)
Arguments
Member_Name
A valid string expression that specifies a member name.
Remarks
The Members (String) function returns a single member whose name is specified. Typically, you use the Members (String) function with external functions, providing to the Members (String) function a string that identifies a member, and the Members (String) function returns the value for this specified member.
Example
The following example uses the Members (String) function to convert the specified string to a valid member, and then returns the default measure for the member specified in the string. The specified string is in single quotes. The default measure is the Reseller Sales Amount measure.
SELECT Members ('[Geography].[Geography].[Country].&[United States] ') ON 0
FROM [Adventure Works]
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for