List only those items, that have several barcodes registered

[holodan95]

Hello All,

I'm currently working with an item list and I have to show those only, that have several barcodes registered.

The problem is, that I need the barcodes as well.

I made a matrix, in which I show the item code, and the distinct count of the barcodes with a filter set to

> 1. This nicely gives me a list of item codes, that have more than one barcodes, however I cannot figure out how

to show the same list, without the number of distinct barcodes, but the actual barcodes.

What I have (with the filter set to barcode distinct > 1)

ItemCode	Barcode (distinct)
ITEM1	2
ITEM2	6
ITEM3	3
ITEM4	4
ITEM5	4

I need:

ItemCode	Barcode (actual)
ITEM1	4445
ITEM1	4498
ITEM2	8887
ITEM2	6659
ITEM2	4447
ITEM2	1113
ITEM2	3325
ITEM2	9956
ITEM3	46456
ITEM3	78784
ITEM3	31312
ITEM4	etc..
ITEM5	etc..

When I add the barcodes as not summarized, and add the filter, it obviously doesn't show anything.

Please help me with a solution!

Thank you!

[holodan95]

Hello All,

I've tried to overcome the problem with a slicer, however it doesn't work either. I add a measure to the slicer (really simple: If(DISTINCTCOUNT(XY) > 1 , 1 , 0) and set it to 1.

While this will only list the correct items in the slicer, when I select "select all" on the slicer menu, it simply doesn't care about the measure I've set as a filter to it. I'm desperate at this point.

[CNENFRNL]

[holodan95]

Hi,

Thank you, but it seems that this will not solve my problem. The list I have has 30M rows, with duplicates. In some cases there is only one barcode to one itemcode. In other cases there are more. I need a list of those item codes, that have more than one barcode pairs, with the actual barcodes showing.