Duplicate Names in a List

[Alta88]

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 show only 1 instance of each rep's name? 

I tried linking the names from a master employee list to this table but the formulas aren't working for me; despite creating a relationship between them. Please advise. 

[v-stephen-msft · Accepted solution]

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]

@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]

Apply that filter as a measure? 

[tamerj1]

@Alta88 

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

[tamerj1]

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

[Alta88]

Ok, so I tried that but it just gave me another column of account IDs.

[tamerj1]

@Alta88 

Ok, now remove the old AcctID from the visual.

[Alta88]

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

[tamerj1]

@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. 

[tamerj1]

Hi @Alta88 

how do you define "first instance"? By date? By index? By a certain sort order? Or any one will be just fine?