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

Accepted Solutions
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
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

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors