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
Expected output - Jason, Bob
Solved! Go to Solution.
Thank you for responding. But this solution doesn't work at 'scale', as the table can have any number of rows.
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!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.