Retrieve a value from one column based on Max. Value of another column to show it in a "Card".

[ThisIsVS]

Let's say I've the following table named as "Table1".

Want to show the name of Salesperson(s) which corresponds to the Maximum of "Total Sales".
If there exists a tie between "n" Salespersons, then output should be <Salesperson 1>, <Salesperson 2> . . . , <Salesperosn "n">.
Example - 
Suppose in the above table,
Michelle has maximum "Total Sales" then the DAX measure should return "Michelle".
But If John, Daniel, Rihanna have the same maximum "Total Sales" then the DAX measure should return "John, Daniel, Rihanna".

[tamerj1 · Accepted solution]

Hi @ThisIsVS 
you can try

Top SalesPerson(s) =
CONCATENATEX (
    TOPN ( 1, Table1, Table1[Total Sales] ),
    Table1[Salesperson],
    ", "
)

[ThisIsVS]

@tamerj1 It didn't work, Sir.

[tamerj1]

@ThisIsVS 
I was expecting that. 

Most probably, the presented data represents a table visual not a data table? It is really essential that you provide accurate information. 
Do sales amount and salesperson belong to the same source data?

Is the Total Amount an aggregated amount or values in a source table column?

[ThisIsVS]

@tamerj1  Changed "Total Sales" summarization to "Sum", It worked. Thankyou Sir. 🙂