A lot of what you're trying to do is dependent on the data structure, which is why we like to see the data (workbook in .twbx format) to understand what might/might not work.
If you take a look at this recent thread (page 2) you'll see something similar to what you're looking to do. Maps - Mileage
If this answers your question please mark it as correct so that others may find it in their search for a solution in the future. Best, Don How to Mark an answer as Correct
We would love to hear your feedback on your Tableau Community Forums experience.
Please take this 5 minute survey.