Forum Discussion
Fact column not summarizing
Hi, this is my first message in this community. 🙂 I have built a model on a CSV file. This model contains several fact columns (sales revenue, discount..). I have also defined the column as facts (...
Hi Claus_Thöle ,
If you try to create a measure to calculate the Sales Revenue, e.g. Sales Revenue = SUM( Sales Revenue ) is that displayed correctly in your table?
The sigma sign being missing from the Sales Revenue column (not identifying it as a fact column) could indicate that there are non-numeric fields in the column such as blank/null values.
Hi Adescrit,
thank you for you reply.
When I create a measure like: Sales Rev = sum([Sales Revenue])
Ii will work correctly. I cant't find any blank or null Value. It also happend in every fact column.
Regards