ALLMEMBER
Similar to the ALL(<Table>)
DAX function, this function evaluates a
given tupleExpression
as if all other model hierarchy references
explicitly reference the hierarchy's ALL
member.
Syntax
ALLMEMBER(tupleExpression)
Input Parameters
tupleExpression
Required. The tuple expression to evaluate. This can be in any supported
tuple syntax, including:
- Canonical static tuple syntax, including key and name member references.
- Canonical dynamic tuple syntax that uses
currentMember
.- Dimensionally-modified tuple syntax, such as
currentMember.lag(), currentMember.parent()
.- A metric reference. In this case, all other dimension hierarchies are implicitly set to the
ALL
member.
Examples
Expands the given tuple to explicitly set the ALL
member for every
model dimension. This prevents BI tool users from influencing the tuple
expression result by grouping or filtering on other dimension
hierarchies.
ALLMEMBER((Mydim.MyHierarchy.currentMember.lag(1), Measures.[salesAmount]))