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.

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

Try 'By Date' since the installs occur on different days but often for the same Sales Rep. 

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

Alta88 

First you slice only by SalesRep. Then you can add AcctID as a measure

CALCULATE ( SELECTEDVALUE ( TableName[AcctID] ), TableName[Date] = MAX ( TableName[Date] ) )

now the values of the other two columns will be aggregated. Maybe this not what you want but please try this and let's see what get then tell me what exactly your requirement is.