I want to apply filters from two tables to count a numbe of items using DAX. Is this possible? In Excel would use vlookup and pivot.
From the two tables, I want to see how many items in the Vegetables category are sold.
Table 1:
Item Category
| Apples | Fruit |
| Bananas | Fruit |
| Belt | Accessory |
| Betroot | Vegetable |
| Candles | Kitchenware |
| Carrots | Vegetable |
| Chair | Lounge |
| Eraser | School Material |
| Foil Wraps | Kitchenware |
| Ice Blocks | Misc |
| Microwaves | Kitchenware |
| Oranges | Fruit |
| Peaches | Fruit |
| Pencils | School Material |
| Phones | Accessory |
| Shirt | Clothing |
| Shoes | Clothing |
| Spinach | Vegetable |
| Spoon | Kitchenware |
| Table | Lounge |
| Watch | Accessory |
Table2:
Items Status
| Apples | Sold |
| Bananas | Instock |
| Belt | Instock |
| Betroot | Sold |
| Candles | Instock |
| Carrots | Instock |
| Chair | Instock |
| Eraser | Sold |
| Foil Wraps | Instock |
| Ice Blocks | Sold |
| Microwaves | Sold |
| Oranges | Instock |
| Peaches | Sold |
| Pencils | Sold |
| Phones | Instock |
| Shirt | Instock |
| Shoes | Sold |
| Spinach | Sold |
| Spoon | Sold |
| Table | Instock |
| Watch | Sold |
