Forum Discussion
why sum up total missing for some columns
I guess you didn't realise the difference between "measure" and "column" in power bi.
Only columns can change the aggregation type(sum, max, min,....) with the end tag. Measure sums need to be written in the formula e.g. Measure = Sum([column])
Please take a look at the blogs and decide which one do you want to create.
Calculated Columns and Measures in DAX - SQLBI
What is the difference between calculated column and measure in Power BI - SPGuides
Paul Zheng _ Community Support Team
I know the difference between measure and calculated column, what I don't understand is: in my table visual, Subscription Deal Value and ILF/OTL are both calculated columns (i.e., columns with formula inside), why column ILF/OTF supports aggregation while Subscription Deal Value fails?
In my report, I already have lots of measures created, so I don't want to create new measure as Power BI can run aggregation on columns.