Custom Column to show duplicates with condition

[qsmith83]

As per screenshot, I need a custom column to show duplicates on the JobID+Ticket column, based on the following conditions:

• if JobID+Ticket contains duplicate, return "Yes" else "No"
• if TICKET_NBR is blank, return "No"

[VahidDM · Accepted solution]

Hi @qsmith83 

Try this measure:

Column =
VAR _Disc =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[JOBID+Ticket] = EARLIER ( 'Table'[JOBID+Ticket] )
        )
    )
RETURN
    IF ( ISBLANK ( 'Table'[TICKET_NBR] ) || _Disc = 1, "No", "Yes" )

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[qsmith83]

@VahidDM, perfect that worked. Thank you.

[amitchandak]

@qsmith83 ,

a new column=

var _cnt = countx(filter(Table,[JobID+Ticket] =earlier([JobID+Ticket]) ),[JobID+Ticket])+0

return

if(isbalnk([TICKET_NBR]) && _cnt <=1 , "No", "Yes")

[qsmith83]

Hi @amitchandak , thanks but it doesn't look right as its only showing all "Yes"

@VahidDM, any suggestions please?