cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
thatjoey20 Frequent Visitor
Frequent Visitor

Total not appearing in the end of the table object

Hello guys, 

 

I am having a problem with a table that is not showing the total of the value, I already tried to solve it by enabling and desabling the function in the menu options but doesn't work.
table.PNG

6 REPLIES 6
ccapowerbi Regular Visitor
Regular Visitor

Re: Total not appearing in the end of the table object

Hey @thatjoey20 !

 

Make sure the column/measure that contains values you are trying to total is formatted so those values are recognized as numbers (i.e., not text).

thatjoey20 Frequent Visitor
Frequent Visitor

Re: Total not appearing in the end of the table object

Yes, they are already mentioned as numbers, I just don't know why is not counting the total

ccapowerbi Regular Visitor
Regular Visitor

Re: Total not appearing in the end of the table object

@thatjoey20 

 

If you are in data view, is Default summarization set up to 'Don't Summarize'? 

 

DontSummarize.PNG

thatjoey20 Frequent Visitor
Frequent Visitor

Re: Total not appearing in the end of the table object

No, because this option is not even avaiable to select. 

Community Support Team
Community Support Team

Re: Total not appearing in the end of the table object

Hi @thatjoey20 

 

It seems you may check the Data type like below.

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Total not appearing in the end of the table object

Hi @thatjoey20 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.

 

Regards

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.