Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Return multiple values from a column based on duplicates

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.   ...
  • TOK's avatar
    4 years ago

    Hey Anonymous,

    try this code. For me it worked perfectly.

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