Forum Discussion

superjam's avatar
superjam
Icon for Helper II rankHelper II
3 years ago

Count repeated values on three columns

Hello:   I have a "Table" with three columns, A, B and C, filled with many different string values. I want to find how many rows of that table have all three columns equal to another row in the ta...
DAX
Duplicates
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi superjam 

try like:
Measure =
COUNTROWS(TableName)-
COUNTROWS(DISTINCT(TableName))
  • superjam's avatar
    superjam
    Icon for Helper II rankHelper II
    3 years ago

    Thank you, FreemanZ 

     

    The function DISTINCT() counts unique values in one column of the table. So, your measure gives the repeated values in one column.

     

    But how about the following example:

    Only one row is duplicated (marked in yellow), because only in that case all three columns are equal with each other. I hope this clarifies the problem.

     

    Thanks again.