Forum Discussion
Post PatronRankx-Ranking should begin when there is a value (not blank) on Ascending rank
electrobrit try this measure
Rank = RANKX( FILTER( ALL( Store[StoreKey] ), [Avg Duration] <> BLANK() ), [Avg Duration], , ASC ) * DIVIDE( [Avg Duration], [Avg Duration] )
Post PatronHave another question, I used this same DAX when trying to get a little more granular with the actual employees. it helped with the same issue (thanks!), rank started with the first person who had actually had a value. However, the avg duration is the same for a lot of people creating duplicate ranks. How do I prevent this?
(I think it will help when I filter on the store too, no duplicates)
Super Userelectrobrit are you trying to rank employees across all the stores or rank the employee within the store?
- electrobrit
actually the requirement is both
- parry2k
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.