Create a Count Distinct Measure
A count distinct measure counts unique occurrences of attributes.
Context
The count distinct measures considers only booked values.
Procedure
- You are in the editor of your analytic model. You can create a new count distinct measure by clicking the background of the canvas and choosing Add Measure in the properties panel. Choose Count Distinct Measure.
- Edit the following properties:
Property
Description
Business Name
Enter a descriptive name to help users identify the object. This name can be changed at any time.
Technical Name
Displays the name used in scripts and code, synchronized by default with the Business Name.
To override the default technical name, enter a new one in the field. Technical names can contain only alphanumeric characters and underscores. - Define the properties of your count distinct measure:
Property
Description
Dimensions
Select the dimensions for which this measure shall be applied.
Formatting
You can change the format of a measure in an analytic model. You can change the scale (Thousand, Million, Billion, Percent) and the number of decimal places.
Settings
Decide whether your measure should be an Auxiliary Measure. An auxiliary measure can be used for further calculation but it will be hidden in the story in SAP Analytics Cloud.