How to get Bottom M 1 excluding zeros
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.
