Rank Question

[raharebecca]

Hi,

Is there a way to rank everything 1-5 for example, even though you have more than 5 variables?

Thanks!

[v-juanli-msft]

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.

[raharebecca]

That's very close, but I would like them quintiled.

[v-juanli-msft]

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.