Create Measure (SUMIF?) for 2 visuals in 2 different data sources?

[abeiswinger]

I have three datasources: Category, Location, and Data.

Category has products broken down by category

Location has City and City, State

Data has Product Names, How Many Sold, City

I have a relationship between the Location (City) and the Data (City) columns... and a relationship between the Category and Data (the Category Column for both).

I have a Map visual that has the cities of clients that buy the product and I have a Donut Chart visual with the Category and Quantity Sold... I want to be able to click on a location on the map and have it adjust the Quantity for that specific location.  Instead, it is adjusting the quantity of that location including the other location data as well.... I hope that makes sense.

If we sold 50% Can Beverages and 50% Bottled Beverages for all locations (17 total)... when I click on one location (Miami), it says we sold 15% Can Beverages and 0% Bottled Beverages (since it's pulling other location data)... I want it to say that Miami has 100% Can Beverages.

[Greg_Deckler]

Sample data please (preferrably that can be copy and pasted.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[abeiswinger]

Hi Greg, is my data given not okay as sample data?  Can it be worked with for a solution?

Thank you

[abeiswinger]

is there a way I can upload a test dashboard?  I thought I remember seeing someone do that before but I don't know how.  

if not, here is the data:

DATA:

City	Category	Quantity	Description
Miami	Can Bev	20	Diet Coke-12 24 CA
New York City	Bottle Bev Carb	30	TRain Ice Orng Mango 11oz 24ca
Denver	Bottle Bev Carb	40	TRain Ice Orng Mango 11oz 24ca
Miami	Can Bev	10	Diet Dr. Pepper-12 24/CS
Denver	Bottle Bev Carb	15	Min. Maid Apple Juice-15.2/24
Dallas	Bottle Bev Carb	22	Min. Maid Apple Juice-15.2/24
Miami	Can Bev	43	Fresca Peach-12oz/24Ca
New York City	Bottle Bev Carb	61	TRain Pch Nectarine12oz 24CA
Denver	Can Bev	40	Diet Sprite Zero-12 24/CS
Dallas	Can Bev	6	Diet Sprite Zero-12 24/CS

LOCATION

City	City, State
Miami	Miami, Florida
New York City	New York City, New York
Denver	Denver, Colorado
Dallas	Dallas, Texas

CATEGORY

Category	Description
Can Bev	Diet Coke-12 24 CA
Can Bev	Diet Dr. Pepper-12 24/CS
Can Bev	Diet Sprite Zero-12 24/CS
Can Bev	Fresca Peach-12oz/24Ca
Bottle Bev Carb	TRain Ice Orng Mango 11oz 24ca
Bottle Bev Carb	TRain Pch Nectarine12oz 24CA
Bottle Bev Carb	Talking Rain BlkRasp-12 24/cs
Bottle Bev Carb	Min. Maid Apple Juice-15.2/24

All cities selected in first screenshot... second screenshot is only Miami, but Miami should be 100% can bev