What is the difference between a measure and calculated column

Hi, lastnn30 

Take an example.

Sample data:

Calculate the overall score for each student.

Calculated column:

Column = 
CALCULATE (
    SUM ( 'Table'[Scores] ),
    ALLEXCEPT('Table','Table'[Student]
))

Measure:

Measure = CALCULATE(SUM('Table'[Scores]),ALLEXCEPT('Table','Table'[Student]))

Here are a few differences:

1. Calculated columns appear in columns in the data view, measure does not, measure only appears in the view.

2. Calculated columns appear in the Model view, not Measure.

Tutorial: Create your own measures in Power BI Desktop - Power BI | Microsoft Learn

Tutorial: Create calculated columns in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

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