Concatenate Rank measure and column

[Anonymous]

Hi All,

  I am facing the issue while concate the measure value and a column. Below is the code sample for the measure.

  Rank = RANKX(ALLSELECTED(EnergyMeterReponses[Squad]),AVERAGEX(RELATEDTABLE(EnergyMeterReponses),EnergyMeterReponses[Energy]),,,Dense)

I want to concate "EnergyMeterReponses[Squad]" with the rank to get the results like below.

1. White Walkers

2. Avengers

..

Thanks,

Sud

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

As I tested, the measure @Zubair_Muhammad posted is right as follows. Please mark the right reply as answer, so more people will get helpful reply as answer. 



Thanks,
Angelia

[Zubair_Muhammad]

Hi @Anonymous

Try this Measure

Measure =
CONCATENATE ( [RANK], ". " & SELECTEDVALUE ( EnergyMeterReponses[Squad] ) )