Return multiple values from a column based on duplicates

[pyampy]

I have a measure that calculates and returns a scalar MAX from a column.

Using this MAX value, I want to return a concatenated string from another column, especially if the table has duplicates.

For e.g. there are duplicate scores of 3 in the table 'PlayerScore' below. I want to use the output to be a concatenated string - 'Jason, Bob'. The reason I want it in this format is to use it within the Smart Narrative widget. 

I tried doing it with LOOKUPVALUE but that returns an error as multiple values are returned. 

My attempt was:

maxScore = CALCULATE(MAX(PlayerScore[Score])) #this returns 3

result = 

LOOKUPVALUE(PlayerScore[Name],PlayerScore[Score],PlayerScore[maxScore]) #this throws an error as multiple values are returned

Expected output - Jason, Bob

Table: 'PlayerScore'

Name	Score
Jason	3
Bob	3
Nancy	1

[TOK · Accepted solution]

Hey @pyampy,

try this code. For me it worked perfectly.

Measure = CONCATENATEX( Filter('PlayerScore',PlayerScore[Score] = Max(PlayerScore[Score])),PlayerScore[Name] ,", ")

[TOK]

I just finished a short tutorial on this topic.

[pyampy]

Thank you!

[smpa01]

@pyampy  try this

_concat =
CONCATENATEX (
    FILTER (
        tbl,
        CALCULATE ( COUNT ( tbl[Name] ), ALLEXCEPT ( tbl, tbl[Score] ) ) > 1
    ),
    tbl[Name],
    ",",
    tbl[Name], ASC
)

[pyampy]

Thank you for responding. But this solution doesn't work at 'scale', as the table can have any number of rows. 

Name	Score
Jason	3
Bob	3
Nancy	1
Paul	5
Eric	3
Devon	5
Alex	5

and so on..

I want to get all the names with max score (which could be change depending on new data) and return it as a string.  For the above example, now 5 is the max score and the expected output would be 'Paul, Devon, Alex'. 

Apologies if I wasn't clear in my original post!