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
5 Replies
- MFelix
Super User
Hi 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).
- amitchandak
rosscortb , Add one more visual level filter , measure >0
rosscortbamitchandak Think I have already done that ?
- amitchandak
rosscortb , Try a measure like
calculate([percentage of hour], filter(values(Table[employee]), [percentage of hour] >0))
and take top N on this
- rosscortb
amitchandak you're the man. Cheers
