Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

pkavar

Tables not showing correct total and it is inconsistence

Submitted by on ‎12-26-2016 08:08 PM

Hello Team,

 

I have one table with couple of rows and define total at the bottom,but it is not showing correct numbers and surprisngly when i export data into csv and used autosum over there ,it looks correct.

Attached images for both the option.powerbi report.pngExport data to csv.png

 

 

Status: Needs Info
See more ideas labeled with:
3 Comments (3 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎12-27-2016 05:58 PM

Hi @pkavar,

 

I tested it in Power BI desktop version 2.41.4581.361, total values display in desktop and after export are the same. Can you share the sample data for our analysis? It would be better if you could share .pbix file.

 

Best Regards,
Qiuyun Yu

Vicky_Song
Impactful Individual
Impactful Individual
‎12-28-2016 10:01 PM
Status changed to: Needs Info
 
Radhika
New Member
‎06-07-2017 09:58 PM

Hi,

 

Even I am facing the same issue. I have a table and i have selected the option 'Show Totals' because of which i get Total below, not able to figure out the formula of total here in the below screenshot - if its an average of the values or anything else.Capture.PNG

I appreciate quick help on this.

 

Idea Statuses