​Deliver instance tables represent the culmination of all the extraction, transformation, and loading that happens prior to the tables being added to the Deliver instance.

This article describes how to add a Deliver instance measure that is based on a table or a field.

Measures can be created based on either a table or fields within the table. The following two sections clarify how to create these two types of measures.

Adding a Measure based on a Table

Use the following steps to add a measure based on a table.

1. Right-click a table and click Add Measure to open the following window.

   

    

2. In the Name box, type a name for the measure.
3. In the Description box, type a description of the measure, which may be available in front-end tools.

   Note: This setting applies to SSAS Tabular and PowerBI Premium endpoints only.

4. In the Type list, “Row Count” is selected since it is the only applicable type for a table based measure.
5. In the Data type list, click on the data type to be used for the value created by the measure.

   Note: This setting applies to SSAS Tabular, PowerBI Premium and Tableau endpoints only.

6. In the Data format list, click on the data format to be used for the field. For some data types, only one data format is available and cannot be changed. Click Customize to customize the data format, e.g. number of decimal places for decimal numbers.

   Note: This setting applies to SSAS Tabular and PowerBI Premium endpoints only.

Adding a Measure based on a Field

Use the following steps to add a measure based on a field.

1. Right-click a field and select Add Measure to open the following window.

   

    

2. In the Name box, type a name for the measure.
3. In the Description box, type a description of the measure, which may be available in front-end tools.

   Note: This setting applies to SSAS Tabular and PowerBI Premium endpoints only.

4. In the Type list, click on the type of measure to be created from the following options:
   • Average: An average of the field values.
   • Count: The number of field values.
   • Distinct count: The number of unique field values.
   • Maximum: The highest field value.
   • Minimum: The lowest field value.
   • Sum: The sum of the field values.
5. In the Data type list, click on the data type to be used for the custom field.

   Note: This setting applies to SSAS Tabular and PowerBI Premium endpoints only.

6. In the Data format list, click on the data format to be used for the field. For some data types, only one data format is available and cannot be changed. Click Customize to customize the data format, e.g. number of decimal places for decimal numbers.

   Note: This setting applies to SSAS Tabular and PowerBI Premium endpoints only. 

​