Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Duplicate Indicator

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...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 NamePart number Current unit price USD 
Customer 11234 $                          559.47
Customer 212345 $                      1,131.17
Customer 31234 $                          410.06
Customer 41234 $                      1,112.48
Customer 512345 $                          569.83
Customer 612345 $                          534.50
Customer 712355 $                          495.00
Customer 812355 $                          406.00
Customer 91234 $                          495.00
Customer 10123 $                            65.04
Customer 11122 $                            79.21
Customer 12124 $                            37.74
Customer 13125 $                            78.48
Customer 14126 $                            61.47
Customer 15127 $                            31.55
Customer 16128 $                            31.15
Customer 17129 $                              1.34
Customer 18130 $                            47.45
Customer 19131 $                            42.44
Customer 20132 $                            34.13
Customer 21133 $                            35.43
Customer 22134 $                            13.94
v-xiaotang's avatar
v-xiaotang
Community Support
5 years ago

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.