Forum Discussion
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, ...
Apply another filter on the measure and select advanced filtering. Select "is not" and input '0'
Apply another filter on the measure and select advanced filtering. Select "is not" and input '0'
Perfect! Thank you so much