Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
28 | |
21 | |
11 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |