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
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

kiwicam is it possible to produce a sample pbix in a very small scale (by getting rid of the sensitive issue) that is representative of the issue. RANKX is a complex function and it would be definitely intetesting to get a chance to take a look at a problematic RANKX. 

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.