Calculate measure when using distance between 2 cities using disconnected tables

DAX DAX Calculations
1

Good morning

I am trying to calculate Tax Revenue and Estimated Population when using a visual that calculates the distance between cities within a mile radius of the selected city. I used the formulas for the distance between cities from a post by Philip Seamark Dynamic Distances in Power Bi, which is working.

I am wanting to add more measures to my table that I have for metrics for the cities that are contained within the measures. This is just a demo file, so not all data is contained within it, however, when trying to show the Tax Revenue, this is displaying what I believe is the tax revenue for every city for the fiscal year, not the individual city. I am having trouble on how to narrow the information for just the cities that are displayed. My distance measures are with the Distance Measures folder. I have been working on this for quite some time now. I know my problem is that the Distance Measures are on disconnected tables from my dataset. Any Assistance would be greatly appreciated.

Range of distance along with other measures.pbix (9.7 MB)

1 Like
2

Hi am really needing assistance with this. Can anyone help? Thank you all for your time.

1 Like
3

Good morning, all. I re-read the Philip Seamark post and realized that the “to City” was actually a table connected to the data. I therefore updated my measures and the “to City” to be items from my table tbl1city. The corrected solution and corrected measures are in the attached file.
Using tbl1city Range of distance along with other measures.pbix (9.7 MB)

1 Like