Data Modelling Issue - CBSA Map

[biuser4]

I have a data model that for the life of me will not do what I'm trying to get it to do - I have no problem doing this in Tableau and need in PBI for integration with 365 in the office.

My setup:

Employees -> joined to Office Location table on location id -> joined to a bridge table on CBSA Location code -> joined to an OES government data set with unemployment rates on CBSA Location Code.

My base map has lattitude and longitude (two separate fields) from the Office location table, count of employees from the employee table (using this as the marker size with no issue.) I'm trying to bring in average unemployment rate by CBSA code for each location - and all PBI will do is average the entire OES data table. I have transformed this table 3 different ways and I can't get it to work. I've tried measures, quick measures, dumbing down the data set, text/integer data type conversion, etc. 

Any thoughts - in any capacity - would be helpful. This is quite frustrating.

[v-yuezhe-msft]

@biuser4,

Could you please share sample data of your table and post expected result here?

Regards,
Lydia

[biuser4 · Accepted solution]

Hi - thank you for replying. I ended up stripping the table down to bare-bones and providing a primitive hard-coded 3 year trend data set that kind sufficed as a low level workaround. I'll Put it back together and provide the sample as I enviosion this becoming an issue again in the future - thanks again.