Can someone explain to me what is wrong with the below DAX formula?. This returns the answer '1' for all the rows.
=RANKX(ALLSELECTED(Sheet1),SUM(Sheet1[Sales]),,ASC)
