Bottom 10 but above zero

[rosscortb]

Hello

I am trying to get the lowest percentage but above Zero as there is loads, any ideas?

Thank
Ross

[amitchandak · Accepted solution]

@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

[amitchandak]

@rosscortb , Add one more visual level filter , measure >0

[rosscortb]

@amitchandak Think I have already done that ?

[MFelix]

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).