Forum Discussion
Composite Key - Duplicates
Hi All, I have the following table : ID Code Date Composite 1 2820 14.07.2024 2 1292 01.06.2024 3 5869 01.01.2024 4 2910 20.11.2024 5 2939 22.06.202...
Hi,
If you want to count the duplicates, then you can use the below measures to achieve that.
First, create a measure to count total rows in the table:
Total Count = COUNTROWS(Composite_Count)Then create a measure to count unique rows based on composite key column you have created:Unique Count = DISTINCTCOUNTNOBLANK(Composite_Count[Composite])Then measure 1 - measure 2 will give you duplicate count:Duplicate Count = [Total Count] - [Unique Count]If this helps to resolve your problem, then mark this as solution provide, thanks!
mickey64
Super User
Super UserStep 1: I add a column.
Step 2: I make a matrix.