How to count recurrences in my table with multiple columns as parameters

[Anonymous]

Hi!

I have a table of client complains and i need to count the recurrences, how can i do that?

a recurrence is a more than one row with the same client id, the same address and the same category.

my table looks like this:

row id | client id | address    |    category

   1           1           St. Paul      not delivered

   2           2           St. Mary     damaged  

   3           1           St. Paul      not delivered

   4           1           St. Paul      damaged

in this case row 4 isn't a recurrence 

[harshnathani]

Hi @Anonymous ,

Create a measure

Recurrence =
COUNTROWS (
    FILTER (
        ALL ( 'Table' ),
        'Table'[Client ID]
            = MAX ( 'Table'[Client ID] )
            && 'Table'[Address]
                = MAX ( 'Table'[Address] )
            && 'Table'[Category]
                = MAX ( 'Table'[Category] )
    )
)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)