Need help with dax

[DiKi-I]

I have a history table with ticket data with duplicates tickets.
I want to find which tickets has only one entry in table.
I want to set some flag value using calculated column. If the ticket exist only once the flag will be Y else N.

How I can do this using dax.

[adudani]

HI @DiKi-I ,

you can watch this video for details : (27) Find Duplicate Values in Dimension Tables - YouTube

Essentially the DAX code for a calculated column is on 3:46 of the video as shown below. Modify this for your data. This will count the number of duplicates in the column specified. 

Then you can create a measure/ column whichever you need for the flag. 

IF( table[check] = 1 ,"Y","N") or use switch true.

if this doesn't resolve the issue, please share a sample input and output with masked data.