In my beginner era as a Power Bi expert, differentiating between a calculated column and a measure, and when to use them was a major challenge. The two are important aspects in Power BI and understanding when and where to use them is key. This article will delve into the two concepts and explain the circumstances where we should use a calculated column or a measure.
Measures in Power BI
A Measure is a calculation created using DAX (Data Analysis Expressions) that is performed on the fly as you interact with your reports in Power BI. Measures are used in visuals, pivot tables, and pivot charts. Unlike Calculated Columns, the calculation is not pre-computed. Putting it in simpler terms, measures are efficient for aggregated calculations.
Calculated Columns in Power BI
A Calculated Column is a column that you add to an existing table in the data model in Power BI. It’s computed during the data loading phase, and the values are stored in the Power BI model. The formula for a Calculated Column is calculated for each row in a table.
Measure Vs Calculated Column
Top comments (0)