Forum Discussion

Kirk_1's avatar
Kirk_1
Frequent Visitor
3 years ago
Solved

RANKX when “Product” appears on multiple rows?

How do I get RANKX to work on filtered data source where same product appears on multiple rows? In this Excel example, the data loads easily into a pivot table for the desired result. As ...
DAX
new measure
RANKX
Kirk_1's avatar
Kirk_1
Frequent Visitor
3 years ago

Hello @tarmerj1

THANK YOU!  Both of your options work, but option 1 is my desired result.

I am going to use:

$ RANK = RANKX(ALLSELECTED(ItemRANK), CALCULATE(SUM(ItemRANK[Dol$ Sales])), ,DESC)

 

 

The fix was to remove [Product] from ALLSELECTED. Thanks @tarmerj1 and FreemanZ, much appreciated.