Forum Discussion

michaelsparrow's avatar
9 years ago
Solved

Columns not coming up in formulas

Hi,   When I click 'New Measure' the columns don't come up in the formula when i click '[' or '''.  They do when i click 'New Column'.   Why is this?   Cheers
  • vanessafvg's avatar
    9 years ago

    measures expect some sort of aggregate function because it is not stored at the row level.  New columns would add a value for each row.  Measure just sum up, or get the max or min or a distinct count.   In order to get a column into a measure you to work you need to apply an aggregate function to a column or call on another calculated measure.