cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Row Context not effective in Maps through a relationship

I have created a couple of measures looking at some call data.  I have a few tables that are associated to create all the relationships.

 

Call Table (with extension) -> Extension Location Assignment Table (Extension to Location Name) -> Location Table (Name, w/ State, region, etc) -> Population Table (associated via state).

 

When I create a table, I can get things working right by disabling any aggregation on the population column for each state.  It does naturally attempt to sum them though and then includes all 50.

 

You can see in the screenshot that the tooltip data won't match up with the table data.  I must be missing something about how maps work.  In the table, I can disable aggregation on the population field which then makes everything else fall in line.  That's not an option for the map.

 

Where am I going wrong here?

 

dkgal_0-1603818892990.png

 

1 ACCEPTED SOLUTION
New Member

I was able to fix the issue by pulling the state information from the population table instead of the intermediaray table.  This forced the system to appropriately limit the count/sum of population.

View solution in original post

2 REPLIES 2
New Member

I was able to fix the issue by pulling the state information from the population table instead of the intermediaray table.  This forced the system to appropriately limit the count/sum of population.

View solution in original post

Microsoft
Microsoft

Hi @dkgal ,

 

I can't get your issue only by your description. Would you please inform us more detailed information( your sample data and expected output (by OneDrive for Business)) if possible? Then we will help you more correctly.

 

Please do mask sensitive data before uploading.

 

Thanks for your understanding and support.

 

Best Regards,

Dedmon Dai

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors