How to stop Power BI tables to not merge two or multiple identical rows that holds same data

[alirazamir]

Hi all, 
I am having an issue where the POWER BI tables are auto merging two or more rows into 1 where the rows holds same data and then aggregating the totals. e.g:

#	Product Name	Price
Row 1	T-Shirt	100
Row 2	T-Shirt	100

Power BI is aggregating the values and shows 1 row rather than 2.

#	Product Name	Price
Row 1	T-Shirt	200

How to stop this. Thanks in advance.

[alirazamir]

Great !! I have added unique id and got the results. Thanks heaps 😊

[andhiii079845]

Right click to the field in the table visual "Don't summerize".

[alirazamir]

@andhiii079845  thanks so much for your prompt response. Now it's not aggregating the totals but it's still showing 1 row rather than 2 rows. How can I fix that ?

[andhiii079845 · Accepted solution]

You are welcome. If the columns are completly unique, you get only one row. you can add a count column to count this.

Power BI is not excel 😉 It want to summerize data in general. 

Or you add your row ID field: