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?
Thank you so much for your help
Solved! Go to Solution.