Forum Discussion
Ranking Issues with Measures
I would like to create a Top 5 and Bottom 5 ranking based off of a Measure that is interactive based off of the filter selections. A picture is posted below(Dummy Data).. That I will further e...
Perhaps something along the lines of:
MyRankTop = RANKX(ALLSELECTED('Table'),[IYA],[IYA],DESC)
MyRankBottom = RANKX(ALLSELECTED('Table'),[IYA],[IYA],ASC)
IsTop5 = IF([MyRankTop]<=5,1,0)
IsBottom5 = IF([MyRankBottom]<=2,1,0)Greg_Deckler Thank you for the reply... Unfortunately this didn't work... It produced multiple lines with the same ranking... I'm looking to have the highest IYA's be ranked the top and the lowest IYA's ranked on the bottom... Any other ideas ?
You'll need to probably play with the "ties" optional parameter of RANKX. An alternative might be to fiddle around with TOPN.
https://msdn.microsoft.com/en-us/query-bi/dax/rankx-function-dax
https://msdn.microsoft.com/en-us/query-bi/dax/topn-function-dax
I will look into this... Thank you for the tips... Anyone else that has recomendation I would be happy to hear them!