Counting occurrences that a value is present more than once in a column

[ChrisR22]

Hello,

I have a dataset that involves tickets closed by employees (see below)

Ticket Assignee	Ticket ID	Date Closed
Smith, Bob (ABC123)	123ABC	1/5/24
Smith, Bob (ABC123), Hill, Jane (DEF456)	456DEF	1/6/24
Hill, Jane (DEF456), Allen, Peter (GHI789), Smith, Bob (ABC123)	789GHI	1/8/24

The parenthesis show the employee code. I am looking to do two things:

1. Count the number of times a ticket has more than 1 assignee

2. count the number of tickets each person closes (regardless of whether they are the sole assignee or one of multiple, they should still get a count of 1 for each ticket they are involved with).

I have split the rows by the delimeter so that each one now has it's own ticket assignee, which has resulted in many rows with the same ticket ID. Is there a formula for a measure that will count all the occurances where a ticket ID occurs more than once?

Does anyone have any thoughts on how to achieve this?

[Ashish_Mathur]

Hi,

Write these measures

Rows = countrows(Data)

Measure = countrows(values(Data[Ticket ID]),[Rows]>1)

Drag the second one to a card visual.

Hope this helps.

[lbendlin]

It is rather unfortunate that a field separator is also used inside a field (the comma in the name)  so the cleanup takes a bit longer.  By the way, absolutely nothing wrong with multiple rows per ticket.

See attached.