Duplicate Indicator

[Anonymous]

Hello,

I am trying to create a custom column that will show me any duplicates I have of a part number. I have a data set that has multiple customers with different prices for the same part number. I want to be able to filter down to only those part numbers and leave anything that only has one customer to the side.

Any help would be awesome! Thank you!

[parry2k]

@Anonymous it is better if you share sample data and expected resultsRead this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490. 

[Anonymous]

Thank you for the information!

I shared some data below. Essentially the idea is that anything below customer 9 would be filtered out of the table since they are unique values, and no other customers have pricing for the part numbers. Whereas customers 1-9 all have different price points for the same part numbers. I want to be able to see those only.

Customer Name	Part number	Current unit price USD
Customer 1	1234	$                          559.47
Customer 2	12345	$                      1,131.17
Customer 3	1234	$                          410.06
Customer 4	1234	$                      1,112.48
Customer 5	12345	$                          569.83
Customer 6	12345	$                          534.50
Customer 7	12355	$                          495.00
Customer 8	12355	$                          406.00
Customer 9	1234	$                          495.00
Customer 10	123	$                            65.04
Customer 11	122	$                            79.21
Customer 12	124	$                            37.74
Customer 13	125	$                            78.48
Customer 14	126	$                            61.47
Customer 15	127	$                            31.55
Customer 16	128	$                            31.15
Customer 17	129	$                              1.34
Customer 18	130	$                            47.45
Customer 19	131	$                            42.44
Customer 20	132	$                            34.13
Customer 21	133	$                            35.43
Customer 22	134	$                            13.94

[v-xiaotang · Accepted solution]

Hi @Anonymous 

try this

create the measure, and put it into the Filter on this visual, then set "is not 1"

countDistinct = CALCULATE(DISTINCTCOUNT('Table'[Customer Name]),ALLEXCEPT('Table','Table'[Part number]))

result

Best Regards,

Community Support Team _Tang

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