Common MDX Functions
To give you a flavor for working with MDX, here is a brief list of commonly used MDX functions types, along with any arguments for each function:
Current:This function returns the current tuple from a set. You should note that this function only works with named sets. You can think of this function as a kind of a
CurrentMemberfunction, but one that is specific to named sets.
DistinctCount: This function returns a count of unique, nonempty tuples in a set.
IIF: This function works similarly to
IIFs (Immediate If) in other applications (Excel, for example). It takes three arguments: an expression, a value to be returned if the expression evaluates to
true, and an alternate value to be returned if the expression evaluates ...