Forum Discussion

kiwicam's avatar
kiwicam
Icon for Helper I rankHelper I
4 years ago

RANKX - Multiple Slicers - What am I doing wrong?

I am trying to use RANKX together with multiple slicers for Month ('Dates'[Month]) and Source ('Data'[Source]) but getting an incorrect result. Rank = RANKX ( ALL (Data[Source] ) , [Sales] ) The un...
Need Help
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
4 years ago
RANKX ( ALLSELECTED (Data[Source] ) , [Sales] )
kiwicam's avatar
kiwicam
Icon for Helper I rankHelper I
4 years ago

Unfortunatetly no as that will limit the group to only 1 source thus always creating a rank of 1.

The rank analysis needs to be over all sources, and then just display the results for the selected source/month.