Dynamics 365 Community Blogs DaxGeek Measures and Measure Groups

Measures and Measure Groups

Hossein.K

6,642

Like ( 0 )

Report

A measure is a column in a table or view that contains data that can be
aggregated. Measures correspond to something that users are interested in
analyzing; such as revenue, profit, or the total number of items sold. A cube can
have one or more measures.

Measures are collected in a Measure Group. A Measure Group contains
measures, dimensions, partitions, and basic information about the measures.
Basic information includes the name of the measure group, type of measures,
storage mode, processing mode, and others.
In a cube, measures are grouped by their underlying fact tables into measure
groups. Measure groups are used to associate dimensions with measures.

Best Regards,

Hossein Karimi