Skip to main content

Calculation Groups

Note: This article is intended for database administrators. Ensure the following tasks are completed by someone with the appropriate database administration privileges.

Note: Released in Jet Analytics Data Integration 6505.1.

Use Calculation Groups to speed up development of measures in Power BI and Tabular endpoints for Deliver instances. This is particularly useful for time intelligence measures — for example, create one Calculation Group Item to calculate last year's values for all other measures, rather than duplicating that logic in each individual measure.

For more information on Calculation Groups, see:

Prerequisites

Calculation Groups are only visible in the Deliver instance model when Tabular and/or Power BI Premium are selected as endpoint types.

  1. Right-click the Deliver instance model and select Deliver Instance Settings.

  2. Ensure that Tabular and/or Power BI Premium are selected as the endpoint type.
Note:

For Tabular endpoints, Calculation Groups are applied on deployment only when Deployment Target is set to Automatic or Universal and the target Analysis Services version is 2019 or above.

Add a Calculation Group

  1. Add the measures to be used in the Calculation Group Items to your Deliver instance.
  2. Right-click Calculation Groups in the Deliver instance and select Add Calculation Group.

  3. Enter a name for the Calculation Group and click OK.
  4. Right-click the new Calculation Group and click Add Item.

  5. Configure the item:
    • Select the relevant endpoint.
    • Enter the formula in the Script section.
    • Map the necessary parameters.
    • Click OK.

  6. Deploy and execute the Deliver instance.

Note: Each Calculation Group Item has an Expression property and a Format String Expression property. The Format String Expression must also be a DAX expression and should be configured to control how the measure result is formatted in the endpoint.

Columns within Calculation Groups

A Calculation Group is created with two columns by default: one column with the same name as the Calculation Group, and an Ordinal column. The Ordinal column is hidden by default and is used to control the order of items within the Calculation Group. Item ordering is determined by the order set in the Deliver instance.

Using Calculation Groups in perspectives

Calculation Groups can be included in SSAS Perspectives. The precedence of a Calculation Group is determined by its position in the Deliver instance. Calculation Groups can be reordered within the Deliver instance using drag and drop.

Was this article helpful?

We're sorry to hear that.