RECAP: Calculated Columns vs. DAX Measures

Maven Analytics
A free video tutorial from Maven Analytics
Award-Winning Analytics & Business Intelligence Training
4.6 instructor rating • 17 courses • 394,991 students

Lecture description

In this lecture, I'll create a little "cheat-sheet" by recapping the difference between Calculated Columns and Measures and outline how and when they're used.

Learn more from the full course

Microsoft Power BI - Up & Running With Power BI Desktop

Transform, analyze & visualize data with Microsoft Power BI Desktop: hands-on demos, projects & 1-on-1 Power BI support

10:43:16 of on-demand video • Updated November 2020

  • Build professional-quality business intelligence reports from the ground up
  • Blend and transform raw data into beautiful interactive dashboards
  • Design and implement the same B.I. tools used by professional analysts and data scientists
  • Showcase your skills with two full-scale course projects (with step-by-step solutions)
  • Understand the business intelligence workflow from end-to-end
  • Learn from a best-selling instructor and professional BI developer
English [Auto] Let's take a minute and walk through a quick recap of calculated columns versus measures in one place. So on the calculated column side these values are calculated based on information from each row of the table. They have row context measures are calculated based on information from filters in the report they have filter context calculated columns. Actually append static values to each row in the table and it stores them in those tables within your model. This increases the file size measures. On the other hand don't create new data in the tables themselves. Therefore they don't increase file size in your model calculated columns recalculate on data source refresh or whenever changes are made to the component columns in the calculation measures or recalculate in response to any change to filters within the report. In other words any time that filter context changes and then calculated columns are primarily used for things like rows columns slicers or filters you often use them as dimensions to change the way you're viewing your data whereas measures are almost always used within the values field of a visual. So when you create calculated columns they live inside of the tables and when you create measures those measured values live within the visuals. So there you have it quick cheat sheet pre-calculated columns versus daks measures.