removal of duplicate records in report builder

[murali5431]

Hi,

I have a dataset as below, where a Pkg ID could duplicate over two invoice numbers.

When I pull a report for Pkg Ids with their dimensions (invoice number excluded), I just need to get unique rows of Pkg ID. Currently the packging IDs are duplicating. Please let me know how I can avoid duplication.

Invoice	Pkg Id	Length	Width	Height
A12	124	3	3	3
B12	124	3	3	3
A12	238	51	72	34
B12	239	51	72	34
B12	240	51	72	34
A12	118	59	41	23
B12	118	59	41	23
B12	121	102	204	13
A12	125	26	112	21

Thanks,

Muralidhar

[Icey · Accepted solution]

Hi @murali5431 ,

When you create table visual in Power BI Report Builder and don't use "Invoice" column, the Pkg Id won't be duplicated. 

Best Regards,

Icey

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

[murali5431]

@Icey Thanks a lot for the response!