Forum Discussion

scabral's avatar
scabral
Helper 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