Please check the attached. The Rank calculation is doing all the work, when set to pane down it will automatically recalculate when you drill down the date dimension. You could also add a date filter to pick a specific day.
Hope this helps.
Top 5 bills.twbx 498.0 KB