Create a Calculated Measure

On the Metric View design page, you can make three types of calculations on existing Metric Views. Based on your selections, the expression will then become an additional column or row in the Metric View. After adding the expression to the Metric View, based on your preferences, it will be listed as a column, row, measure, or slice.

Note: To create or view calculated measure in SSAS, refer the SSAS documentation.

Procedures

Access the Metrics and Scorecards page.
In the Metric View list, select .

The design page for the Metric View appears.
In the Cube box, select the cube for which you want to create a Metric View.

Note: The Cube drop-down list box contains the cubes that you have permission to access.
Select .

The Calculated Measure window appears.
As needed, enter the values in the available fields.
Select OK.

The Calculated Measure window closes, and the calculated measure name appears in the Data/Measures section.

Note: If you have performed a calculation on the Metric View, the Drillthrough button is disabled. You cannot drill through a calculated measure.