Function

[Rsing]

What is difference between Calculated Column and Measure.

[amitchandak · Accepted solution]

@Rsing, Refer: https://medium.com/microsoft-power-bi/power-bi-interview-questions-part-1-4982de3be327

Calculated Columns:

A calculated column is a column you add to a table in your data model.

Calculations are performed row by row, and the results are stored in a new column.

It is important to note that the calculation formula is applied individually to each row of data, and the result will be fixed for each row.

Calculated columns cannot use visual filters or slicers.

Calculated columns are best suited to calculations that depend on individual row values, such as concatenations, string manipulations, or simple arithmetic operations.

Calculated columns are static and cannot be used for Dynamic aggregation or calculations across multiple rows or tables.

Measure:

A measure is a calculation that aggregates or computes across multiple rows or tables.

The formulas used in measures adapt to different contexts, thus resulting in dynamic outputs. These calculations are utilized in reporting tools to combine and filter model data based on various attributes.

A measure is used to summarize data in visualizations, such as charts and tables.

Calculations are applied based on visual or report context.

Measures are dynamic and adapt to the data displayed in a visual, depending on filters and slicers applied to the report.

These measures are best suited for use when performing calculations like sums, averages, counts, and many other types of aggregations across a wide variety of datasets.

In summary, Calculated Columns are used for row-level calculations that create new static columns in a table, while Measures are used for aggregations and calculations that summarize data and provide dynamic results in visualizations. The choice between the two depends on the type of calculation and the level of granularity required in the analysis.

https://www.youtube.com/watch?v=JoHxzC0JHMU&t=1s