Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Column vs Measure

I am very new to Power BI and Still not understanding the difference between calculating a column vs calculating a measure. Below I am working on a DAX that is giving me different values for the sam...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    You'd better create measures.

    Calculated Columns vs Measures 

    Measure 2 = 
DIVIDE(
    MAX('Table (3)'[Column]),
    MAX('Table (3)'[Loads])
)

Average_measure = 
AVERAGEX(
    ALL('Table (3)'),
    [Measure 2]
)

    If you want to create columns, you can do like this:

    Column 2 = 
DIVIDE(
    'Table (3)'[Column],
    'Table (3)'[Loads]
)

Average_column = AVERAGE('Table (3)'[Column 2])

     

    Best regards,
    Lionel Chen

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

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

You'd better create measures.

Calculated Columns vs Measures 

Measure 2 = 
DIVIDE(
    MAX('Table (3)'[Column]),
    MAX('Table (3)'[Loads])
)

Average_measure = 
AVERAGEX(
    ALL('Table (3)'),
    [Measure 2]
)

If you want to create columns, you can do like this:

Column 2 = 
DIVIDE(
    'Table (3)'[Column],
    'Table (3)'[Loads]
)

Average_column = AVERAGE('Table (3)'[Column 2])

 

Best regards,
Lionel Chen

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