What is a measure and what is a dimension conceptually?

< 1 min read

A dimension is a descriptive attribute that provides context to data, like date, region, customer, or product.
It helps slice, filter, and group the data for analysis.
A measure is a numeric value that represents performance or quantity, like sales amount, profit, or order count.
Measures are typically aggregated using sum, average, or count.
In a sales dashboard I worked on, “Product Category” and “Region” were dimensions.
“Total Sales” and “Revenue” were measures used to track performance.
Dimensions answer the “by what” question, while measures answer the “how much” question.
Together, they help convert raw data into meaningful business insights.

Power BI Essentials