Working with duplicate records

[Anonymous]

I have data of the given format

batch	records	payment method	country	region	pay description
1	30	Amex	US	Americas	card invalid
1	30	Amex	US	Americas	card limit exceeded
1	30	Amex	US	Americas	card invalid
1	30	Amex	US	Americas	card invalid
2	60	Mastercard	JP	ASIA	Insufficient balance
2	60	Mastercard	JP	ASIA	invalid zipcode
2	60	Mastercard	GB	EMEA	card expired
3	80	VISA	GB	EMEA	card expired
3	80	VISA	GB	EMEA	card expired

i am trying to present records values in unique format in power BI. to show distribution and trend.

but when i rollup it gets summarized.

Has anyone seen this before and can provide a solution

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

Due to the characteristics of powerbi, if there is exactly the same data between rows, it will be automatically omitted in visual and only one row will be displayed. If you want to distinguish them, the easiest way is to add an index column in PQ.

Like this:

If it doesn't solve your problem, Please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

In any visual when you these column

batch

records

payment method

country

region

you will get unique data

or you can create meusre like

measure = countx(summarize(Table, [batch],[records],[payment method],[country region]), [Batch])

or can create table summarize(Table, [batch],[records],[payment method],[country region], "Max" , max([pay description])),