Forum Discussion

lastnn30's avatar
lastnn30
Icon for Post Patron rankPost Patron
3 years ago
Solved

What is the difference between a measure and calculated column

Hi Simple google will show that this question has been asked many times and many videos and articls about it. However the more I read or watch video, the more I am confused. I would appreciate if yo...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

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.

 

  • osmangokturk44's avatar
    osmangokturk44
    New Member
    2 years ago

    Actually the name of the measure appears in the model view, but it is not seen in the dataset as a column. You see its name as a column, but you cant see its content. But you can use it in the report.