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
MFelix
Super User
Super UserHi rosscortb
Please see this post regarding How to Get Your Question Answered Quickly (courtesy of @Greg_Deckler) and How to provide sample data in the Power BI Forum (courtesy of @ImkeF).