Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi!
I'm experiencing an issue where I have a column that is already set to Whole numbers, and all of my other columns are also set to whole numbers, yet the one column will not sum when I bring it into a visualization. It also won't have the Greek Sum symbol appear next to the line when I'm manipulating data, but when I got into edit queries, it shows that it is a number.
How do I solve this?
Thanks!
Solved! Go to Solution.
In the table you can set the summarization behavior for a column. My guess is it's set to 'Don't summarize' for the column that is causing you problems.
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
You may also try Change how a numeric field is aggregated and use SUM to add a measure.
What if it's a measure and not a table column that won't sumamrize?
You may also try Change how a numeric field is aggregated and use SUM to add a measure.
In the table you can set the summarization behavior for a column. My guess is it's set to 'Don't summarize' for the column that is causing you problems.
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |