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
KNP's avatar
KNP
Icon for Super User rankSuper User
4 years ago

It might be worth showing a screenshot of your data model just in case something in the relationships is causing an issue.

 

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

Please see below.

The only relationship is the transaction date with the date table, so I don't think the cause lies here.