Excluding Blank For Ranking the Total Sales

[Anonymous]

I want to rank the vendors name based on their total sales. I am using the dax formula below, but I came to know that the highest sales is for Blank and ranked 1. Can anyone please help me to remove the blank and start counting from 1.

Month Rank = RANKX(ALL('Vendors'), SUMX(RELATEDTABLE(Sales), [Sales in $]))

[amitchandak · Accepted solution]

@Anonymous , Try like

Month Rank = RANKX(filter(ALL('Vendors'), not(isblank(SUMX(RELATEDTABLE(Sales), [Sales in $])))), SUMX(RELATEDTABLE(Sales), [Sales in $]))