How to get Bottom M 1 excluding zeros

[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.

[Anonymous]

Is there a way to write something that says
IF result = 0 then 

    FILTER(

        System_Users,

        RANKX(

            System_Users,

            Audit[Sum Audits and Entries],,

            ASC,

            DENSE

        ) = 2 
Else 1 

[lazurens2]

Maybe this to return positives only into the measure : 

Least COUNT =
VAR _rank = CALCULATE(
    Audit[Sum Audits and Entries],
    FILTER(
        System_Users,
        RANKX(
            System_Users,
            Audit[Sum Audits and Entries],,
            ASC,
            DENSE
        ) = 1
    )
 ) + 0
VAR Result = If ( _rank > 0 , _rank )
Return 
     Result 

Good luck !

[Anonymous]

Great thought. Unfortunately it just removes the results with zero.

[Anonymous]

Visualization Filters