cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sud Regular Visitor
Regular Visitor

Concatenate Rank measure and column

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-huizhn-msft Super Contributor
Super Contributor

Re: Concatenate Rank measure and column

Hi @Sud,

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. 

1.PNG

Thanks,
Angelia

2 REPLIES 2
Super User
Super User

Re: Concatenate Rank measure and column

Hi @Sud

 

Try this Measure

 

Measure =
CONCATENATE ( [RANK], ". " & SELECTEDVALUE ( EnergyMeterReponses[Squad] ) )
v-huizhn-msft Super Contributor
Super Contributor

Re: Concatenate Rank measure and column

Hi @Sud,

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. 

1.PNG

Thanks,
Angelia