Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Excluding Blank For Ranking the Total Sales

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like

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

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try like

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