cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
diogoalmeida Regular Visitor
Regular Visitor

Bottom N without blanks and zeros

Good morning all,

 

I have a measure that is a ratio between the sum of two columns and with this measure I want to give the top 5 and bottom 5 values. I have no problems with the TOP 5, although, I have several examples that this ratio is 0, so when I want to get the 5 bottom values, power bi gives all the zero values. I've applied another filter in order not to show the zeros, however I have to change my bottom 5 to bottom N, in order to get the lowest 5 values that I want to be represented.

 

Is there any possibility get the bottom 5 values that are bigger than 0 and not have to fix mannually the BottomN?

 

forum.JPGforum2.JPG

 

Thank you so much for your help

 

Best regards

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Bottom N without blanks and zeros

Apply another filter on the measure and select advanced filtering. Select "is not" and input '0'

2 REPLIES 2

Re: Bottom N without blanks and zeros

Apply another filter on the measure and select advanced filtering. Select "is not" and input '0'

diogoalmeida Regular Visitor
Regular Visitor

Re: Bottom N without blanks and zeros

Perfect! Thank you so much