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 the blank and start counting from 1.
 

 

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

 

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 $]))

1 Reply

  • 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 $]))