Content Comparison

...

Some of the measure properties have an i icon next to their name. Click the icon to learn more.

Adding a measure using a field

To add a measure using a field, perform the following steps.

From Toolbox, select Semantic Models.
Select a semantic model and click the Add Measure button, which is the plus sign next to the column name.
1. If there are no measures or groups, a measure group is added.
2. If a measure is selected, another measure is added to the group.
3. If a measure group is selected, a measure is added to that group.
To add a measure group, click the down arrow next to the plus sign and click Add Measure Group.
Click the measure or measure group and enter a name in the Properties panel.
Do one of the following:
1. Drag a measure into a group.
2. Right-click the measure group, click Add Measure, and enter a name for the measure.
If there is no default measure, click the Default checkbox to make this measure the default used for new visualizations.
Click to show a field.
1. Select a field from the list or click Search and enter a name or part of a name to find it faster than scrolling.
2. Click the arrow next to the node name to expand the list and view the field names.
Select a Function from the list, such as Sum.
To change the Format, click the Actions menu (…) button to change the default number format.
1. Select a choice from the list and enter the desired values.
2. For certain fields, you can also select display units such as $, or lbs., and enter the value in the units field.
3. You can also click to select Include Thousands Separators.
4. Click Apply.
Enter a Display folder name.
If raw data querying is enabled, specify whether to Materialize the measure.
Optionally, select the Visible checkbox to display the measure for use in worksheets. If you don’t want users to use this data directly, you can clear it.
Optionally, add a Description of up to 200 characters. The description is used when you hover the cursor over the measure in a worksheet.
Click Save.