Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
fiter the rank1 column between 1 and 10 in order to show 10 rows, the rank is based on total_tb1 column, and may have same rank, so the data may have more than 10 rows, then follow the rank of Account name, in order to show exactly 10 rows.
Solved! Go to Solution.
Hi @Anonymous
You can try these measures:
rank2 = RANKX(ALL('dataset'[Account]),CALCULATE(MAX('dataset'[Account])),,ASC,Dense)
rank3 = [rank1]+[rank2]*(0.001)
You can also combine the three measures into one measure.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
I sloved almost the same way, Thank you!
Hi @Anonymous
You can try these measures:
rank2 = RANKX(ALL('dataset'[Account]),CALCULATE(MAX('dataset'[Account])),,ASC,Dense)
rank3 = [rank1]+[rank2]*(0.001)
You can also combine the three measures into one measure.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
First question would be how would you choose between the competing rows. Perhaps you can look at the logic of computing Rank by adding Account name (or some other relevant column/measure ) also after Total_tb1 to get the unique ranks (Rank1).
I see, the order follow the sequence:rank1, then the Account name.
I may have some problem with how to rank the Account name after rank1
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |