Performance difference between calculated column or measure?

Hi Anonymous ,

As far as I know, there are many differences between Dax calculated column and Dax measure.

1. 

When we finish the dax code of calculated column, it will takes up resources like memory. However, measure won't takes up resources when it is finished. So we could see calcualted column directly in data view and couldn't see measure .  Measure will take cpu to calculate the result when it is used in visualizations.

2. 

Measure couldn't be added into slicer or filter levels which are higher than visual level filter, but calculated column can.

3. Dax measure will caculate aggregation values but calcualted column will calcualte based on rows.

So you need to choose dax measure or dax calculated column based on your requirements.

For refernece:

Calculated Columns and Measures in DAX

Power BI Measures vs Calculated Columns

And you can refer to this offical blog to learn more details about how to optmize Power BI data model.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.