Forum Discussion
Solved
Count duplicate values
Is there a way to count the number of rows in a column that have duplicate values? I have a column with a large list of names and I just want to count the number of names that are repeated and return...
I figured out a solution that worked for my data.
I created a calculated measure that subtracted the DISTINCTCOUNT of the Names from the DISTINCTCOUNT of the unique identifier in the table.
The difference is the amount of names with multiple rows in the table.
I actually came across a brilliant and the most easy way to do this.
All you have to do is first select a column from which you want to find duplicate text. Then select any another associated column. This will give you a table like structure.
Now in the "Values" area, select that second column and go "Count".
You can now filter greater than or equal to 2.
You can then create another visual so it filters through as per your selection.