Forum Discussion
RANK for MIDDLE 10
Hello,
I would like to know if there are any way to put a RANK where I'll devide the ROWs RANKED and this MIDDLE value I want to get -5 and +5 from this middle number and become a graphic called MIDDLE 10
Example:
So, basically I want to bring these 10 rows as result.
I did try so many things but, no idea how to do it.
Anonymous , Try measure like below in place of Average measure
measure =
var _max = maxx(Table[Name]), [Rank])
return
Calculate([Average], filter(Values(Table[Name]) , [Rank] >5 && [Rank] <= _max -5))
2 Replies
- amitchandak
Super User
Anonymous , Try measure like below in place of Average measure
measure =
var _max = maxx(Table[Name]), [Rank])
return
Calculate([Average], filter(Values(Table[Name]) , [Rank] >5 && [Rank] <= _max -5))
amitchandak Your syntax seems very clarifying for me, it deffinitely will sort my problem but I forgot to mention one thing. - I couldnt make the RANK column, I'm also struggling to RANK based on average.
Once I fix the RANK, I can apply your formula to set the middle ones