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...
Greg_Deckler
Community Champion
Community ChampionYou'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!