Forum Discussion

electrobrit's avatar
electrobrit
Icon for Post Patron rankPost Patron
7 years ago
Solved

Rankx-Ranking should begin when there is a value (not blank) on Ascending rank

RankX is confusing to me so hoping someone can help me through this. I have stores that have an average duration of a task. The lower the better (so I have to sort asc), but if there is no "averag...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    electrobrit try this measure

     

    Rank = 
RANKX( 
FILTER( ALL( Store[StoreKey] ), 
[Avg Duration] <> BLANK()  
), 
[Avg Duration], , ASC ) * 
DIVIDE( [Avg Duration], [Avg Duration] )
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

electrobrit are you trying to rank employees across all the stores or rank the employee within the store?

electrobrit's avatar
electrobrit
Icon for Post Patron rankPost Patron
7 years ago

actually the requirement is both

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    electrobrit rank employees across all the dataset should be the same as we did for Rank for stores but yes ranking of employees withing store will need another enhancement to existing measure which I will post soon but in the meantime employee rank you should be able to get going.