Forum Discussion
rosscortb
Post Patron
Post PatronBottom 10 but above zero
Hello I am trying to get the lowest percentage but above Zero as there is loads, any ideas? Thank Ross
rosscortb , Try a measure like
calculate([percentage of hour], filter(values(Table[employee]), [percentage of hour] >0))
and take top N on this
amitchandak
Super User
Super Userrosscortb , Add one more visual level filter , measure >0
rosscortbPost Patron
Post Patronamitchandak Think I have already done that ?