Export data doesnt match

I think I have an answer to this problem, please, correct me if I am wrong.

Recently on Power BI training one of my students asked the same question.

He has a Table visual with data and for number columns he set Don't Summarize to see each transaction. After making Export Data for that visual he got CSV and totals in CSV were not matching total in Power BI (which was correct).

The problem is that when you set a table (or other visual) number columns with Don't Summarize, what happens is that Power BI hides completely identical rows (removing duplicates) and you get wrong results in exported CSV file.

I hope that attached picture may help to understand the cause.

The solution is to add some kind of column in that table, that will add any kind of unique ID's for that rows. If there is no such column with natural ID's, then adding Power Query's index column may help.