Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
Hi @Anonymous
Try this Measure
Measure = CONCATENATE ( [RANK], ". " & SELECTEDVALUE ( EnergyMeterReponses[Squad] ) )
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |