Creating measures

A calculated measure performs aggregation in the model efficiently by processing calculations on the server during query time. Measures can be defined using simple aggregate functions, or they can include complex business logic by using combinations of functions.

Getting ready

In a Tabular Model, a table can play two roles either as a container for measures (often referred to as a measure group or fact table) or a lookup table (often referred to as a dimension table in multidimensional models). When a model is processed, the Tabular processing engine determines the role of tables and applies the appropriate metadata to them in the final model. If a table has non-summarized or non-numeric columns, it shows up in the client application as a lookup table and these columns become attributes. If a table has numeric columns that can be summarized or it contains defined measures, it may be presented by the client tool as a measure group. If a table contains the attribute columns...