Forum Discussion

QLD_Jay's avatar
QLD_Jay
Frequent Visitor
8 years ago
Solved

RANK.EQ If statement ignoring 0

Hi All,   I'm attempting to use the RANK.EQ function to produce TopN and BottomN tables that can be filtered by rank.   Currently I have a TopN column that ranks Device CPU usage totals from high...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    QLD_Jay

     

    Try with RANKX

     

    =
IF (
    'All Device CPU Rank Table'[Total] <> 0,
    RANKX (
        FILTER (
            ALL ( 'All Device CPU Rank Table'[Total] ),
            'All Device CPU Rank Table'[Total] <> 0
        ),
        'All Device CPU Rank Table'[Total],
        ,
        ASC
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

QLD_Jay

 

Try with RANKX

 

=
IF (
    'All Device CPU Rank Table'[Total] <> 0,
    RANKX (
        FILTER (
            ALL ( 'All Device CPU Rank Table'[Total] ),
            'All Device CPU Rank Table'[Total] <> 0
        ),
        'All Device CPU Rank Table'[Total],
        ,
        ASC
    )
)
QLD_Jay's avatar
QLD_Jay
Frequent Visitor
8 years ago

Thanks Zubair,

 

Worked exactly as required.

 

I attempted RANKX prior to RANK.EQ and for the life of me couldn't get anything but 1's out of it.

 

Cheers!