Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

RANKX on filtered table

Apologies if this is obvious, i have not been able to find a solution for this.   I have this measure  RANKX(ALLSELECTED(Table1),CALCULATE([measure), , DESC)   I would like to filter Table 1 so...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

     

    =
IF(
    MAX( table1[PUBLISHED] ),
    RANKX(
        CALCULATETABLE( ALLSELECTED( table1[some column] ), table1[PUBLISHED] = TRUE ),
        [measure]
    )
)

     

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

 

=
IF(
    MAX( table1[PUBLISHED] ),
    RANKX(
        CALCULATETABLE( ALLSELECTED( table1[some column] ), table1[PUBLISHED] = TRUE ),
        [measure]
    )
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Brilliant, this works perfectly, thanks for your help.