Power BI

pls see the documents below

 

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns?wt.mc_id=DP-MVP-5004616

 

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-measures?wt.mc_id=DP-MVP-5004616

 

Calculated Columns and Measures in DAX - SQLBI

Hi Rsing ,

Based on my testing, please try the following samples to learn the difference between calculated column and measure:

1.Create the simple table.

2.Create the calculated column to filter the scores.

score filter = 
var score = 'Table'[test scores]
RETURN
IF(score <= 220, "<=220", 
    IF(score >= 250, "250+", "221-249"))

3.The calculated column can directly define variable by column name. The result is displayed in the table.

4.Create the new measure to filter highest score for each student.

Highest Score = 
CALCULATE(
    MAX('Table'[test scores]),
    ALLEXCEPT('Table', 'Table'[Student])
)

5.Measure is used to maximum through the field. Drag the measure into the bar chart.

You can also view the following documents to learn more information.

Measures in Power BI Desktop - Power BI | Microsoft Learn

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

 

Best Reagards,

Wisdom Wu

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