How to get second rankx when first rankx result = 0

[Anonymous]

Hi,

I am trying to get the next bottom ranked value that is not zero. This is what I currently have written to return the first ranked lowest value.

Least COUNT =

CALCULATE(

    Audit[Sum Audits and Entries],

    FILTER(

        System_Users,

        RANKX(

            System_Users,

            Audit[Sum Audits and Entries],,

            ASC,

            DENSE

        ) = 1

    )

 ) + 0
Results

Need it to return 31. I am new to power BI so any help is greatly appreciated.

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please try

Least COUNT =
VAR FilteredTable =
    FILTER ( System_Users, [Sum Audits and Entries] <> 0 )
RETURN
    CALCULATE (
        Audit[Sum Audits and Entries],
        FILTER (
            FilteredTable,
            RANKX ( FilteredTable, [Sum Audits and Entries],, ASC, DENSE ) = 1
        )
    ) + 0

[Anonymous]

It worked!!!!! Yay!!! Thank you v much!!