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]
    )
)

     

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,

 

you can use the FILTER function to filter something.

And if you use a measure you don't need a CALCULATE without any parameters. Try the following approach:

RANKX(FILTER(ALLSELECTED(Table1), Table1[myColumn] = "MyValue"),[measure], , DESC)

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Denis,

     

    I have tried this but it is still giving ranks to rows that do not have that value:

     

    RANKX(FILTER(ALLSELECTED(table1),table1[PUBLISHED]=true),[measure] , ,DESC)