Getting stores list that hadn't sold the product

[goviican22]

Hi Guys,

I'm trying to get a list of stores (from the total stores selected by the slicer) that has 0 sales from selected product (through slicer).

What's the best way to do this?

Let's say:
Product 1

Product 2

Product 3

and 

Store 1

Store 2

Store 3

[amitchandak · Accepted solution]

@goviican22 , Refer to this. In Your case the customer is store /product and Category is Product/Store, Depending on what you need

Power BI Items/Categories not sold to the customers
Power BI Items/Categories not sold to the customers: https://youtu.be/AbuKvAnicwo