Forum Discussion
Identify Duplicate Values in a Table using a measure
You don't need a measure for this. You can do it directly using the table visual by counting the "Number" for each product. You can use a table visual in which you add the Product column and Number column twice. The first Number column will be the Number itself and the second Number column will be aggregated by count as shown below. You can then sort or filter by "Count of Number" on anything greater than 1 which indicates a duplicate.
You don't need a measure for this. You can do it directly using the table visual by counting the "Number" for each product. You can use a table visual in which you add the Product column and Number column twice. The first Number column will be the Number itself and the second Number column will be aggregated by count as shown below. You can then sort or filter by "Count of Number" on anything greater than 1 which indicates a duplicate.