Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Columns not adding up correctly

Hi, 

 

Just looking for a bit of help regarding the addition of values in my table. I have uploaded all of my data from an excel sheet and when I put the data into tables the columns do not add up correctly. Just wondering if anyone could offer any advice please. I have posted an example below: 

 

Column A

4

2

1

5

6

Total - 11 (total should be 18)

5 REPLIES 5
Anonymous
Not applicable

Hi- could you pelase post a screenshot? It sounds like you might be using a distinct count (counts each unique value, so only counts apples once instead of each time apples appear) instead of a normal count.


Anonymous
Not applicable

Hi

Have you made sure to format the numbers as integers?

Anonymous
Not applicable

Hi, It is not numbers I am working with, for example if I have a list of all fruit it will count how many 'apples' are in my spreadsheet, so it is working with words rather than numbers. 

Anonymous
Not applicable

Hi

In that case, go into the table. Under fields, select the little arrow next to the value and you can choose "Show value as" -> "Percent of grand total".

If it doesn't work with strings, you can add a column to your dataset with the count, so for each column of apple the value is 1. Then you can do the above, it works for sure with integers.

Let me know if this help.

Anonymous
Not applicable

Capturepowerbi.PNG

Please excuse the poor edit. Cannot post real data due to confidentiality Smiley LOL 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.