Forum Discussion

scabral's avatar
scabral
Icon for Helper IV rankHelper IV
4 years ago
Solved

Create dynamic Ranking measure

Hi,   have the following table:   Classification Division  Operations Value Year Healthcare Eastern Boston 1,000,000 2021 Helathcare Western Los Angeles 500,000 2021 Healt...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi scabral ,

     

    The formula should be:

    Measure = Rankx(ALLSELECTED('Table'),CALCULATE(Sum('Table'[Value])),,desc,dense)
    Otherwise it will always return 1.
     
    Best Regards,
    Jay
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi scabral ,

 

The formula should be:

Measure = Rankx(ALLSELECTED('Table'),CALCULATE(Sum('Table'[Value])),,desc,dense)
Otherwise it will always return 1.
 
Best Regards,
Jay