Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data Modelling question

Hi,   I might need some insight on how to model the next analysis. I have two tables: "Reservations" and "Dealers" Each table has Latitude and Longitude coordinates and I would like to plot both ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous,

Can please share some dummy data with a similar data structure with expected results to test?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi, 
Thanks for answering thus far.
Here is a view of what the data looks like.

DealerReservation

 


As mentioned in my first post, I have to plot this data on a map visual.
The part with which I'm struggling is when the user would select a Year.
Only reservations have a date column and dealers don't, if your user would select a year this would filter out the Dealer data and this is not what I would like to achieve.

I would like to show the dealers always and based on the selection on date it need filter out the reservations.
In Power BI I have already combined the 2 tables, but I can't figure out how I can write a measure which does this.

Below are the results that I expect.
I have achieved this by creating 2 different measure (for the left table visual), but since map visuals don't allow 2 series, I need to solve this in 1 single measure.

 

 

 

KR,

Kevin