Forum Discussion
SUMMARIZE Function
Halo People So the summarize function dont seem to work as expected, see below. The error does not make sense, since the expression is merely a sum(table[tonnes column) and I just saw someone in ...
I think you are trying to create this as Measure, Navigate to Modelling -> New Table, ad use the formula there.
Thanks
Raj
The SUMMARIZE command will create a new table. It really seems you're trying to use it in a measure, which will not work. So, first make sure you are at the "Data view" when you use it (not on the report view). I'd also make sure that your columns/fields, such as "Tonnes & Carats" are properly reference, usually in the "Table[Field]" format.
Regards.
Aha, I feel silly thank you very much. This makes a lot of sense