Season 1

Namaste Power BI

Episode 11

Calculated Columns vs Measures

⏱ 40:00

Episode Summary

The most misunderstood concept in Power BI — when to use calculated columns (row context, stored at refresh) vs measures (filter context, computed at query time). Getting this wrong ruins performance.

This is Episode 11 of the free Namaste Power BI course on DevWithData — covering calculated columns vs measures. Watch the video above, then pass the MCQ checkpoint to unlock the next episode and update your Data Readiness Index score.

Key Takeaways

→Calculated columns: evaluated row-by-row at refresh, stored in memory
→Measures: evaluated dynamically based on current filter context
→If you need to slice/filter by a value → calculated column
→If you need an aggregation that responds to filters → measure

⚠ Common Interview Pitfalls

•Using calculated columns for totals (they compute per row, not per visual)
•Creating a measure when you need a fixed row-level value
•Not understanding that calculated columns increase model size

Official Reference

Deepen your understanding with official Microsoft documentation.

PL-300 Official Training Course

Microsoft's official instructor-led training for the Power BI Data Analyst certification.

https://learn.microsoft.com/en-us/training/courses/pl-300t00

Power BI Documentation

Complete reference for Power BI Desktop, Power BI Service, and Power BI Embedded.

https://learn.microsoft.com/en-us/power-bi/

Content on DevWithData is original and inspired by official Microsoft resources. The links above point directly to Microsoft Learn — always the authoritative source.

← Ep 10: Date Table & Time Intelligence

Ep 12: Context Transition →

Episode Checkpoint

Sign in to attempt the quiz and unlock the next episode.