Forum Discussion
why sum up total missing for some columns
I have created a table, in the values fields are columns from a fact table.
For some reason, when I add some new columns to the table, the values didn't get summed up on the bottom. both columns are in whole number format, so I don't understand why totals are missing for them.
4 Replies
Hi,
I am trying to create a 'pivot table' in PB will will automatically sum up a numeric field via the implicit measure.
However, it looks PB doesn't create an implicit measure for the field Subscription Deal Value (max 5 yr) (€). When I hoover over the field, it doesn't show the sum up calculation.
the field ILF/OTL seems to work normally, PB does the sum up automatically, so I don't need to create a sumup measure for it.
I don't understand why the implicit measure doesn't work for the first field. This is a numeric column in my fact table, the column is set up as 'whole number' , summarization formula is 'sum'. I don't see any error in the column, so I don't understand why implicit measure fails to work.
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.
