Forum Discussion

Alta88's avatar
Alta88
Icon for Helper IV rankHelper IV
4 years ago
Solved

Duplicate Names in a List

I'm working on a ranking project and I have a list of sales rep names that features names that repeat over and over since each rep has several accounts they've installed. How do I get this table to s...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Alta88 ,

     

    The easiest way is set the field to show the first.

    Before

     

    After

     

     

    Best Regards,

    Stephen Tao

     

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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Alta88 

Another method. Place this measure in the filter pane, select "is not blank" and apply the filter

 

FilterMeasure =
VAR CurrentRepTable =
    CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[Sales Rep] ) )
VAR MinDate =
    MINX ( CurrentRepTable, TableName[Date] )
VAR FilteredTable =
    FILTER ( CurrentRepTable, TableName[Date] = MinDate )
RETURN
    COUNTROWS ( FilteredTable )

 

  • Alta88's avatar
    Alta88
    Icon for Helper IV rankHelper IV
    4 years ago

    Apply that filter as a measure? 

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Yes. But no need to place in the table, only in the filter pane

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Alta88 

      Oh I'm extremely sorry. I posted the wrong measure for another post. Please refer to the same comment updated with correct measure.