Forum Discussion

salim's avatar
salim
Advocate I
10 years ago
Solved

Divide one column by another

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?

 

Need Help
  • Sean's avatar
    Sean
    10 years ago

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

2 Replies

  • Sean's avatar
    Sean
    Community Champion
    10 years ago

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

    • salim's avatar
      salim
      Advocate I
      10 years ago

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