Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have a column that is setup like in the image that is not summing. When I use it in a table it does not summarize by fund, and the table does not provide a total. The column seems properly set up to sum but Power BI appears to see it differently.
Below is side-by-side a table that is summing and totaling (on a different column) and one that is not. Yes I have checked that the column on the left has the same settings on the ribbon as the column on the right.
Solved! Go to Solution.
Check formats, If it is number stored as Text then it wont offer to Sum as Adding Text is unpossible. Make sure it is a number format.
The other thing I check first is to select the table and visualizations section make sure the values are not set to do not summarize when you click the down arrow beside them.
Thanks for the tip on uploading images. Here they are (the drag and drop was not working yesterday).
This is the column set up on the modeling ribbon. Below that are two tables that should be giving the same summarized result. The one on the left uses a column that is derived from the column on the right. I ought to be able to have the column on the right summarize like the column on the left.
Check formats, If it is number stored as Text then it wont offer to Sum as Adding Text is unpossible. Make sure it is a number format.
The other thing I check first is to select the table and visualizations section make sure the values are not set to do not summarize when you click the down arrow beside them.
Thanks DSimma. It was the table visualization choosing a different summarization than is the default on the column.
Before I mark that as the solution, does anyone have an explanation why two columns that appear to have exactly the same properties on the Modeling ribbon pick up a different default when used in a table?
My screen shots do not appear to be showing. Maybe someone can share the magic trick for making those work as well.
@uBoatCaptain Make sure that when you click the "Photos" button ( I assume you are grabbing a snippet of the table or something that creates an image), select the image, and wait until the image loads in the preview pane... kinda weird upper right corner. THEN, click ok, if you do it prematurely the image won't load.
As to the sum.. without the image it's hard to tell, but is the data type correct on the column?
My screenshots do not appear to be showing. Maybe someone can share the magic trick for making those work as well.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
88 | |
82 | |
64 | |
49 |
User | Count |
---|---|
125 | |
111 | |
88 | |
69 | |
66 |