Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Is there a way to rank everything 1-5 for example, even though you have more than 5 variables?
Thanks!
Hi @raharebecca
Would you like to create a rank like [rank 2] ?
If so, you could create measures
rank1 = RANKX(ALL('Table'),CALCULATE(SUM('Table'[Value])),,ASC) rank2 = IF(MOD([rank1],5)<>0,MOD([rank1],5),5)
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That's very close, but I would like them quintiled.
Hi @raharebecca
What do you mean by "quintiled"?
Could you show an example based on a simple example?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |