Calculated columns vs measures in Power BI - Quick Revision & Key Differences

Recall & Review

beginner

What is a calculated column in Power BI?

A calculated column is a new column added to a table using a formula. It is computed row by row when data is loaded or refreshed and stored in the data model.

beginner

What is a measure in Power BI?

A measure is a calculation used to aggregate data dynamically based on filters or slicers. It is computed on the fly when you interact with reports.

intermediate

When should you use a calculated column instead of a measure?

Use a calculated column when you need a value for each row that can be used in slicers, filters, or relationships. For example, categorizing data by a new label.

intermediate

How do measures improve report performance compared to calculated columns?

Measures calculate results only when needed and based on current filters, so they use less memory and can be faster than calculated columns which store data for every row.

beginner

Can a measure be used in a table visual like a calculated column?

Yes, measures can be used in table visuals but they show aggregated results based on the current filter context, not row-by-row values like calculated columns.

Which of the following is true about calculated columns?

A They are calculated once and stored in the data model.

B They calculate results dynamically based on filters.

C They cannot be used in slicers or filters.

D They only work with numeric data.

Calculated columns are computed once during data refresh and stored in the model for each row.

What is a key advantage of using measures over calculated columns?

A Measures are stored in the data model for each row.

B Measures require more memory than calculated columns.

C Measures cannot be used in visuals.

D Measures calculate results dynamically based on user interaction.

Measures calculate results on the fly depending on filters and slicers, making reports more flexible.

When would you prefer a calculated column over a measure?

A When you need a value for each row to create relationships or filters.

B When you want to aggregate data dynamically.

C When you want to reduce data model size.

D When you want to calculate totals only.

Calculated columns provide row-level values useful for filtering and relationships.

Which statement about measures is FALSE?

A Measures respond to slicers and filters.

B Measures can be used in charts and tables.

C Measures calculate values for each row individually.

D Measures are not stored in the data model as columns.

Measures calculate aggregated results, not row-by-row values.

What happens when you add a calculated column to your data model?

A It cannot be used in visuals.

B It increases the size of the data model.

C It creates a dynamic calculation based on filters.

D It reduces the data model size.

Calculated columns add data for each row, increasing the model size.

Explain the main differences between calculated columns and measures in Power BI.

Think about when calculations happen and how results are stored or displayed.

Describe a scenario where you would choose a calculated column instead of a measure.

Consider when you want to slice or filter data by a new attribute.