Forum Discussion

Christianvs's avatar
Christianvs
Icon for Helper II rankHelper II
3 years ago
Solved

Update index when filter is applied to table

Hi   I am trying to figure out the best way to implement a self updating index column and I asked a question yesterday that is related to this but in a slightly different fashion.    My question ...
  • PaulDBrown's avatar
    3 years ago

    Let the table containing the Index column be 'Index Table'

    Try this measure:

     

    New index =
    RANKX (
        ALLSELECTED ( 'Index table' ),
        CALCULATE ( SUM ( 'Index table'[Index] ) ),
        ,
        ASC,
        DENSE
    )