So when you create your denseRank function, you said it was not working. Is it not allowing you to create the calculated field or is it producing incorrect results?
Another option that could make this easier for me to assist further; if you’re able to upload a sample copy of your analysis with anonymized data to Quick Sight Arena, I can test out a few different options.