Can't remove "-" from top 10 ranked list?

[Anonymous]

Hi all,

I've cretaed a rank measure for GWP and selected to only display the top 10 of that rank in a matrix, but for some reason it shows me a duff entry of "-" that is rank 48? Any clue how to remove this?

Kind regards,

Jordan  

[amitchandak · Accepted solution]

@Anonymous , check how to remove value from filter

https://community.powerbi.com/t5/Desktop/RANKX-excluding-blanks/td-p/396044
https://community.powerbi.com/t5/Desktop/RANKX-Ignore-blank-zero-across-time/td-p/436949
https://community.powerbi.com/t5/Desktop/RANKX-without-zeros-and-blanks/td-p/599558

[Anonymous]

Perfect, thank you Amitchandak!