Forum Discussion

raharebecca's avatar
raharebecca
Frequent Visitor
7 years ago

Rank Question

Hi,   Is there a way to rank everything 1-5 for example, even though you have more than 5 variables?   Thanks!
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

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's avatar
    raharebecca
    Frequent Visitor
    6 years ago

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

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      6 years ago

      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.