cancel
Showing results for 
Search instead for 
Did you mean: 

Ranking

Super User
4028 Views
Highlighted
Super User
Super User

Ranking

This is a simple measure but one that I have used countless times for ranking of products or in this example Surfers and their prize money.

 

This rank can also be used in conjunction with the TOPN or BOTTOMN filters 

 

NAME:

Rank per category

 

DESCRIPTION:

Calculate the rank of the base value within the category

 

PARAMETERS:

Name: Base value

Tooltip: The value you want to average

Type: Numerical field / measure

 

Name: Category

Tooltip: The category in which you want to calculate the rank

Type: Categorical field

 

DAX:

Rank {Base value} per {Category} =

RANKX(

  ALLSELECTED({Category}),

  {Base value}

)

 

 

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"