Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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] ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |