Custom Member Formulas for Dimensions

Sometimes we need to add some virtual members to a dimension, such as calculating the total value for regions excluding a specific area.

Dimension Calculated Members

Virtual members of dimension calculation formulas and calculated members of measures are achieved by creating a Calculated Member.

For example, to create a member in the [Customers] dimension to calculate the total value for regions in the USA excluding California, the dimension member formula can be written as: