Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Remove deplicate rows based on lowest number

I am struggling to get this working. This is a small portion of my dataset. My dataset only contains TicketId, CommentId (not shown here, not really important), and CommentDuration. CommentDuration ...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    Kindly check below results:

    Measure = var a = CALCULATE(MIN('Table (2)'[CommentDuration]),ALLEXCEPT('Table (2)','Table (2)'[Ticketid]))
return 
IF(MAX('Table (2)'[CommentDuration])=a,a,BLANK())

     

v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi Anonymous 

 

Kindly check below results:

Measure = var a = CALCULATE(MIN('Table (2)'[CommentDuration]),ALLEXCEPT('Table (2)','Table (2)'[Ticketid]))
return 
IF(MAX('Table (2)'[CommentDuration])=a,a,BLANK())