Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Returns the system-generated data member that is associated with a nonleaf member of a dimension.
Member_Expression.DataMember
Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.
This function operates on nonleaf members in any hierarchy and can be used by the UPDATE CUBE Statement (MDX) command to writeback data to a nonleaf member directly, rather than to the leaf member's descendants.
Note
Returns the specified member if the specified member is a leaf member, or if the nonleaf member does not have an associated data member.
The following example uses the DataMember function in a calculated measure to show the sales quota for each individual employee:
WITH MEMBER measures.IndividualQuota AS
([Employee].[Employees].currentmember.datamember, [Measures].[Sales Amount Quota])
,FORMAT_STRING='Currency'
SELECT {[Measures].[Sales Amount Quota],[Measures].IndividualQuota} ON COLUMNS,
[Employee].[Employees].MEMBERS ON ROWS
FROM [Adventure Works]
MDX Function Reference (MDX)
Key Concepts in MDX (Analysis Services)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register today