Forum Discussion
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. 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!
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.
3 Replies
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.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 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.
