topic Calculate geographic zones based in sales data in DAX Commands and Tips

Calculate geographic zones based in sales data

arielqs — Sun, 16 Jun 2024 04:22:29 GMT

I have a lot of geographic data about my customers, but I want to calculate the geographic zones that I need to administer.

For example, if I want to distribute my country in 4 commercial zones based on the dispersion of the sales, how can I divide the country so that I can have some kind of "clusters" to define potential directors? What if I decide 5 zones?

I would like to make that kind of decisions with Power BI. I started using Azure Maps and using the bubble cluster layer but it was not what I was looking for.

In summary, I want to create a Power BI where combining M, DAX and Maps (maybe custom visuals?) so that it can helpe me to define how I can divide my country in n zones based on the geographic dispersion of my customers and their sales.

Thanks in advance

Re: Calculate geographic zones based in sales data

lbendlin — Mon, 17 Jun 2024 17:00:15 GMT

plot your Latitude and Longitude values in a scatter plot and then ask for automatic clustering.

Re: Calculate geographic zones based in sales data

Anonymous — Tue, 18 Jun 2024 03:12:30 GMT

Hi arielqs ,

Thanks for the reply from lbendlin .

Do you want to divide regions according to sales data?

Please try:

Here is the sample data I created:

State	Sales
Alabama	1000
Colorado	2500
Florida	2200
Kansas	1680
Maine	2120

The sample data I created is the state names and sales data of the US. When using Filled Map, the place names can be automatically recognized. If your place names do not support recognition, you can use longitude and latitude instead of place names.

Filled Map can divide regions according to data, so why not use this visual object?

The visual effect of the page is as follows, and you can see that the regions are divided very well.

I would be grateful if you could provide me with the pbix file or sample data.

Remember to remove sensitive data and do not log in to your account in Power BI Desktop when uploading the pbix file.

If you have any other questions please feel free to contact me.

The pbix file is attached.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Re: Calculate geographic zones based in sales data

Anonymous — Thu, 27 Jun 2024 09:19:30 GMT

Hi arielqs ,

Did lbendlin and I's answers help you solve your problem?

If the answers helped you, please mark the answers as solutions. This will be of great help to other users who have similar problems as you.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team