Forum Discussion

DiKi-I's avatar
DiKi-I
Icon for Post Partisan rankPost Partisan
2 years ago

Need help with dax

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.

Need Help

1 Reply

  • adudani's avatar
    adudani
    Icon for Memorable Member rankMemorable Member
    2 years ago

    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.