Skip to main content

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]))