topic How to count recurrences in my table with multiple columns as parameters in DAX Commands and Tips

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

Anonymous — Tue, 23 Jun 2020 14:22:21 GMT

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

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

Anonymous — Tue, 23 Jun 2020 17:18:15 GMT

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)