Calculate (MDX)
Populates each cell with an aggregate value without modifying calculated members.
Syntax
CALCULATE
Remarks
The Calculate function provides a method for allowing the cube to aggregate according to the cube's default behavior. The contents of a nonleaf cell are null before the CALCULATE statement is applied. Afterwards, the Calculate function populates cells with aggregates, custom members, and more.
Note
The Calculate function can only be run in the context of the entire cube. This function is not supported under the SCOPE statement.