Divide one column by another

[salim]

I have a column saying C1 = CALCULATE(SUM(column1)). It shows 50 in one.

Then I add another column C2 = CALCULATE(COUNT(column1)). It shows 2 in the same previous row.

Then I add column C3 = C1 / C2. Then I receive 50 for the same row!

AVERAGE does not work either. Any thoughts?

[Sean · Accepted solution]

Convert these Columns into Measures... M1, M2 and M3

[salim]

Thank you! I guess that is because the difference between measure and column are still blurry to me.