Mapping Average Delivery Time

[IDoLogistics]

Hi All,

I am looking to map average delivery time across the US, and have the average delivery time correspond to the coloration on the map akin to what is shown below (Delivery Map Example). I think that the best map might be a "Filled Map", but I am open to other sources. I am pulling all of my data from SQL, and then using Power BI to calculate the number of working days that it takes for each delivery. For my data, I have zip code for each delivery as well as the time in days that it took for the delivery to occour. I have made several attempts at trouble shooting, but haven't really figured out a soloution. I will also include a mall excerpt of my data set with some obfuscation of sensitive informaiton. 

(Delivery Map Example)

Attempts:

1) I tried using a measure to average out the delivery time, but that measure doesn't want to be added to the legend located in the map.

2) I have also tried using the the column for the number of delivery days in the "Legend" field, but, Power BI seems to be pulling the first result instead of the average from the data points. 
3) I tried using a simple summarized table, but the results are binary.

Attempt 3 Example

(Data Set Example)

edit: Further information on ask, and limited details on data source.

[IDoLogistics · Accepted solution]

Summarized fields were not correctly created. This process was solved using summarized fields and finding the average throught that method.

[HoangHugo]

Hi

I think you should put your avarage measue to Bubble size, not "Legend"

[IDoLogistics]

Hi HoangHugo,

Thank you for your response, and I may not have made my issue as clear as I could have. I will put in an edit to my original post. I am trying to use a "Filled map" to illustrate the change in delivery time by zip code. Ideally I would be able to have a map that would clearly illustrate that the further away from a DC that an area is located, the greater the time to deliver. While this could be done with a bubble, i'd prefer to have a region colored in order to show a mapped deliniatioin of time to deliver.

Logs