Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Values | AgreementsNotes | Rank | Output = concatenate | Output: Value |
1 | Hi | 4 | Hi, How are you, I am fine, Thank you | 1 |
1 | How are you | 3 | ||
1 | I am fine | 2 | ||
1 | Thank you | 1 | ||
2 | good | 3 | good,to,see u | 2 |
2 | to | 2 | ||
2 | see u | 1 | ||
3 | all | 2 | all, ok | 3 |
3 | ok | 1 | ||
4 | great | 1 | great | 4 |
5 | thanks | 1 | thanks | 5 |
Hi @Jasleen123 created a calculated column for rank
Hi @techies
This will give incorrect rank for values 2 (Ranking will be alphabetically so using Sheet13[AgreementsNotes] col will give incorrect ranking).
so index is required for the correct ranking
yes
Hi @Jasleen123
Can you please try this
----------1st measure----------------------------
If you got your answer then Please accept it as solution.
Need to create the "Rank" column as well as it is not pre-defined in the table I used.
as you have mentioned in the below :
SELECTEDVALUE('Table'[Rank]) = MaxRank,
'Table'[Rank] = ??????
Please provide the measure for this Rank column as well.
Thanks,
Jasleen
Hi @Jasleen123
To create rank col.
First Create index col---
Go to Power Query --> Add col --> index col (start from 1)
save and load it
Now create calculated col for rank using below DAX.
Do the rest of the steps as I posted before.
If this answers your questions, kindly accept it as a solution.
Give kudos for this if it is helpful.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |