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
kiwicam's avatar
kiwicam
Icon for Helper I rankHelper I
4 years ago

Unfortunately no.

I guess I will just keep looking for a solution.

Thank you anyway.

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

So, I was able to scrub the data and share a sample file.

20211129_Sample.pbix (14MB) 

However, it is really weird; every time I open the file it seems a different source does not match up.

In the screen shot below SCR 01 is incorrect when filtered, but earlier today I saw SCR 03, SCR 07 and SCR 14 incorrect at different times of the day.