Select multiple source data items for a measure calculation

You can select multiple source data items from any of the configured data sources to configure measure calculations.

Select multiple source data items for a measure calculation

1. Click the Edit Calculations button.

2. In the Context & Calculations editor, click the required aggregate calculation.

3. Click Select source. The Select source data items dialog box appears.

   The Source data items area shows the available filtered schema of the data sources.

4. Click Expand to expand the data source and view the source data items within the data source.

   Note: You can use the Find box to search for a source data item.

5. Select a source data item from which you want to expose the fields to add the source data item. Deselect a source data item to move an item back to the Source data items area.

   The names in a data source table should not contain the special character, semicolon (;). The names that contain special characters like semicolon (;) and (#) do not appear in Source data items pane.

   The bottom grid of the dialog box shows the fields of the source data item that you select in the Source data items pane. The first source (from the top of the list) providing a value for the field will be used in the resulting dimension table.

6. Drag to enable the Preview source data option to view sample data from the data source.

7. Click OK.

   The source data items and source data item fields are exposed to the measure. You can use the exposed source data items and source data item fields to configure measure calculations.

   For more information, see Add a measure calculation.