Forum Discussion
RANKX(ALL SELECTED… DAX causing duplicates
Here is my DAX expression: $ RANK = RANKX(ALLSELECTED('Store-Level'), CALCULATE(SUM('Store-Level'[$])), ,DESC) This DAX works in my smaller filtered table (right), but I have another larger filt...
Manoj Nair,
It did take a lot longer to process using that, but unfortunately it did not work. It still shows duplicated ranks, like the majority of the top $ sales items have a "1" as the the rank number.