Measure Types

Depending on the type of model, the following measure types are available:

Type of measure	Description
Aggregation	You need to set the aggregation type (sum, average, count, max, min).
Derived Measure	A derived measure refers to another measure and allows restrictions on available attributes.
Count Distinct	Counts unique (tuple) occurrences of attributes (e.g. in case multiple rows contain the country "Germany", it is counted only once).
Calculation	A calculated measure references other measures and allows the combination of measures with elementary arithmetic (operations of addition, subtraction, multiplication, and division), and also more complex functions like maximum/minimum, IF (as function), mathematical functions like round, and conversion functions like convert to decfloat.
Fixed Value	Define a fixed value that can be used for further calculation.
Converted Currency	You can define all the parameters you need to convert currency values into another currency.