TechNet
Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Collapse the table of content
Expand the table of content
Expand Minimize

Members (String) (MDX)

 

Updated: March 2, 2016

Returns a member specified by a string expression.

  
Members(Member_Name)   

Member_Name
A valid string expression that specifies a member name.

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.

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]  

MDX Function Reference (MDX)

Community Additions

ADD
Show:
© 2016 Microsoft