How to get second rankx when first rankx result = 0
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.
How to exlude SUM of zero
Hi, Here is a measure SUM (0+0+0+0.6+0.6+0.6...) divided by COUNT of dates. The question is how to exclude those dates when summary equals 0.00 from this calculations? Currently it calculates: 4.2 / 12 = 0.35 I need it to calculate: 4.2 / 7 = 0.6 the reason 0.00 is showing for some dates is because in the data there is 0.6 but later on there was another data added with -0.6 for those dates. Hence below we see the summary. Thank you!
