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 rel...
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