Forum Discussion
RANKX drill down matrix not working
Hi, i am trying to create a rankx that recalculates when you drill down in a matrix table i have tried about 100 different ways currently my table looks like this; the top lev...
Anonymous
Your measure is correct but the order in which you ordered the columns needs to change from lower to upper, try this measure, please.Endleaf Rank = SWITCH ( TRUE (), ISINSCOPE ( Sales[Product] ), RANKX ( ALLSELECTED ( Sales[Product] ), [Total Points],, DESC, DENSE ), ISINSCOPE ( Sales[Store] ), RANKX ( ALLSELECTED ( Sales[Store] ), [Total Points],, DESC, DENSE ), ISINSCOPE ( Sales[Month] ), RANKX ( ALLSELECTED ( Sales[Month] ), [Total Points],, DESC, DENSE ), ISINSCOPE ( Sales[Sales Executive] ), RANKX ( ALLSELECTED ( Sales[Sales Executive] ), [Total Points],, DESC, DENSE ) )________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy
Super User
Super UserAnonymous
Your measure is correct but the order in which you ordered the columns needs to change from lower to upper, try this measure, please.
Endleaf Rank =
SWITCH (
TRUE (),
ISINSCOPE ( Sales[Product] ), RANKX ( ALLSELECTED ( Sales[Product] ), [Total Points],, DESC, DENSE ),
ISINSCOPE ( Sales[Store] ), RANKX ( ALLSELECTED ( Sales[Store] ), [Total Points],, DESC, DENSE ),
ISINSCOPE ( Sales[Month] ), RANKX ( ALLSELECTED ( Sales[Month] ), [Total Points],, DESC, DENSE ),
ISINSCOPE ( Sales[Sales Executive] ), RANKX ( ALLSELECTED ( Sales[Sales Executive] ), [Total Points],, DESC, DENSE )
)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy thank you so much, have been struggling with this for so long