Ranking by value

[Anonymous]

I have a matrix with data on category and brand level. I have succeed to make a rank measure to be able to have the ranking on Brand level with a category. However my measure ranks the brands and category on alfabetical order, so if I want to rank the matrix by MAT Value, then the Ranking MAT measure for brands doesn't work, Other brands is nr 5 but the first in the list because of the value.

What I need is just a tweak of the measure, so I want to rank the whole matrix by MAT value and within that keep my ranking by brand within the category.

This is my measure which needs to be adjusted I think:

Ranking MAT =

VAR ProductsToRank = [Waarde van TopN]

VAR Ranking =

CALCULATE(

rankx( FILTER(allselected( 'Brand names'),'Brand names'[Brand]<>"Other brands"), [MAT Value]))

VAR IsotherSelected = SELECTEDVALUE('Brand names'[Brand]) = "Other brands"

VAR IsCategory = SELECTEDVALUE('Brand names'[Brand],"Category")

VAR Result =

IF(IsCategory="Category","",

IF(IsotherSelected, ProductsToRank,

IF ( Ranking <= ProductsToRank, Ranking, Ranking + 1) ))

Return

 Result

[Anonymous]

Hi @Anonymous ,

Do you expect the result to be an ordering of the red numbers below?

You need to group according to Dermatological Care in the RANKX function.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Yes like the red numbers, but I have several categories following, so not just by Dermalogical care, but category by category.