Missing rows in table after selecting Do Not Summarize

[nsaray]

Hi

In my data table, there are 2 transactions which I want to display in PowerBI

By default, PowerBI summarises the 2 rows into 1 line for a total of 40k. I need to display 2 rows of 20k but when I select Do Not Summarize, it only displays one row of  20k. Would anyone know how I could fix this so that it shows 2 rows of 20k?

[amitchandak]

@nsaray , are these two-row exactly duplicate of each other in visual. Power bi table is distinct when there no summarization on any of the column, In case these some with summarization rest are grouped. Add an index column and add that to your visual

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi