What's the difference between Measure and Column?

In Power BI, * * Column * * and * * Measure * * are the main components of data modeling, but they differ in processing and usability, as follows:

---

# # # 🔹 * * Column (column) * *

* * is: * * Data fields that are computed or loaded directly into the table (Data Table)

* * Type: * * Can be either * * Calculated Column * * (Created with DAX) or * * Imported Column * * (Derived from source material)

* * Important characteristics: * *

* Calculate * * in Row Context * * - i.e. create a new field calculated from the data of each row

* Processed and stored in * * Model Memory (In-Memory) * *

* * * Visual, Slicer, Filter, Group by, and Relationship * *

* Fits data preparation such as mixed customer code generation, grouping

* * DAX EXAMPLE: * *

"'dax.

FullName = Customers [FirstName] & "& Customers [LastName]

"'

---

♪ # # 🔸 * * Measure (Mecher) * *

* * is: * * Summary calculations such as * * Total, Average, Count * * calculated according to the interaction of the report

* * Type: * * Calculate * * when display * * Only (* * No Precharge * *)

* * Important characteristics: * *

* * * Filter Context (Context-aware) * * - Depends on the filter used in Visual

* * * Relationship cannot be created or used in Slicer directly * *

* Used to display summary information such as Total Sales, Avg Profit

* More memory saving than Column

* * DAX EXAMPLE: * *

"'dax.

TotalSales = SUM (Sales [Amount])

"'

---

🔄 Compare Column vs Measure

Issues:

Compute when

☆ Column: Calculate when loading data

✍ Measure: Calculate when rendered in Visual

Store in memory

✍ Column: Yes (In-memory)

☆ Measure: NON (Calculated according to Context)

Used in Slicer / Filter

✍ Column: Yes

✍ Measure: not directly

Used to create Relationships

✍ Column: Yes

✍ Measure: Not

Consume Memory

☆ Column: More than Measure

✍ Measure: Less than

---

# # # ✅ When to use

* ✅ * * Column: * * If a new field is required to build a relationship, Slicer, or want to be pre-computed.

* ✅ * * Measure: * * If you want to calculate the sum, average, or summary values that change according to the report filter.

---

Design and Report with Power BI

Contact LINE ID: 0882274252

---

Training courses

https://analyst-development.net/Course/Schedule