Group, Sum, and Rank DAX Formula Creation Issue

Hi,

Thank you for your response Ibarrau. I think I am following what you are saying. Within a Chart, I could make one Axis the 'DocumentNo' (Expense Report Number) and then the 'Amount' field in the Value and do a Sum by Amount function in the Value field. I believe this would then allow me to see which 'DocumentNo' are the largest, smallest, etc.

But, at this point, we are trying to cut corners and create an "All-in-One" formula, if you will. We'd first like to create a 'Measurement' value for the 'DocumentNo' column which would Sum the 'Amount' column at every change in 'DocumentNo'. From there we want to be able to create a new column and plug our created'Measurement' into a RANKX (ALL() formula that will provide a ranking from highest to lowest based on the Total Summed Amounts for the different DocumentNos (Expense Reports). I have included Screenshots of the 'DocumentNo' and 'Amount' Column.

I know this is probably a bit confusing, but I appreciate all the input/help you all can give.

Thanks,

Zach J