Fact column not summarizing

[Claus_Thöle]

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 (type: decimal, summarize: sum).

But when I use the column it is not summarizing.

The column is also not displayed in the model as a fact columns.

Here you can download the file.

What am I doing wrong?

Thanks in advance!

[Adescrit]

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.

[Claus_Thöle]

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