Measures inherit certain properties from the measure group of which they are a member, unless those properties are overridden at the measure level. Measure properties determine how a measure is aggregated, its data type, the name that is displayed to the user, the display folder in which the measure will appear, its format string, any measure expression, the underlying source column, and its visibility to users.
Property
Definition
AggregateFunction
Required. Determines how measures are aggregated. Sum is the default aggregation. For more information, see Use Aggregate Functions for a description of each function.
DataType
Required. Specifies the data type of the column in the underlying fact table to which the measure is bound. This value is inherited from the source column by default.
Description
Provides a description of the measure, which may be exposed in client applications.
DisplayFolder
Specifies the folder in which the measure will appear when users connect to the cube. When a cube has many measures, you can use display folders to categorize the measures and improve the user browsing experience.
FormatString
You can select the format that is used to display measure values to users by using the FormatString property of the measure.
Although a list of display formats is provided in SQL Server Data Tools, you can specify many additional formats that are not in the list. You can specify any named or user-defined format that is valid in Microsoft Visual Basic.
ID
Required. Displays the unique identifier (ID) of the measure. This property is read-only.
MeasureExpression
Specifies a constrained MDX expression defining the value of the measure. The expression is evaluated at the leaf level before being aggregated, and allows for weighting of a value. For example, in currency conversion where a sales amount is weighted by the exchange rate.
In this module, you'll learn how to work with implicit and explicit measures. You'll start by creating simple measures, which summarize a single column or table. Then, you'll create more complex measures based on other measures in the model. Additionally, you'll learn about the similarities of, and differences between, a calculated column and a measure.
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.