Skip to main content

Overview of Calculated Measures and Members

Overview of Calculated Measures and Members

In MDX, you can create a calculated member, which is a member based on other members. You can define two kinds of calculated members: ones that are measures and ones that are not. (Remember that a measure is considered to be a member of the MEASURES dimension.)

  • A calculated measure is based on other measures. For example, one measure might be defined as a second measure divided by a third measure.

    The phrase calculated measure is not a standard MDX phrase. This documentation uses the phrase for brevity.

  • A non-measure calculated member typically aggregates together other non-measure members. Like other non-measure members, this calculated member is a group of records in the fact table.

    For example, suppose member A refers to 150 records in the fact table, and member B refers to 300 records in the fact table. Suppose that you create a member C that aggregates A and B together. Then member C refers to the relevant 450 records in the fact table.

FeedbackOpens in a new tab