Forum Discussion
Create Measure (SUMIF?) for 2 visuals in 2 different data sources?
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.
3 Replies
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
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
Hi Greg, is my data given not okay as sample data? Can it be worked with for a solution?
Thank you
