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

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 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
      7 years ago

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

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 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.