Summarization Issue

[PBCIT]

Hello all,

I am having an issue. I have a Power BI with two tabs. In the first tab, I have a table that summarizes (by summarize, I mean by right-clicking on the column in the fields menu and selecting "Sum") and sums 2 columns, a quantity column and a total price column. In the second tab, I have a table where I want to see all the transactions that occurred without it being summarized on a row-level. I right-clicked on the columns in teh fields menu and selected "Don't summarize" expecting it to give me the same data, just without combining like line items together, however, when I exported the table to excel and did an autosum function, I noticed that the totals were different. I went and did a small amount of sample data within the table and realized that the quantity column changes drastically and appears to perhaps only be showing distinct value combinations. I have examples below:

Summary Report Example
Descript	QtyWithAllow	TotalCost
SODA DIET COKE	16.00	$19.84
S/O*3 BROWNIE PERUV CHOC	1.00	$1.41
GRILL/GRIDDL RVRS CST IRN	1.00	$46.62
Total	18.00	$67.87

Detail Report Example
Descript	QtyWithAllow	TotalCost
SODA DIET COKE	2.00	$2.48
S/O*3 BROWNIE PERUV CHOC	1.00	$1.41
GRILL/GRIDDL RVRS CST IRN	1.00	$46.62

Neither of these columns are measures and are just simply the data that comes from the data source. What could be causing this issue? I appreciate any help anyone can provide.

[PBCIT]

I've actually found a solution. I just added the id into the column and kept the summarizations on on the detail table and it appears to have worked

[parry2k]

@PBCIT that's exactly what I proposed, it needs something unique, summarizes or not, that is secondary, the purpose is to make the row unique.

[parry2k · Accepted solution]

@PBCIT yes detail will show distinct values, add some index column in the table which is unique and you will get every row. 

I would 💖Kudos 🙂 if my solution helped.