Finding Brands Missing From Stores

[matd13]

Hello Experts:

I have a dataset that lists the store number and accompanying brand. I need to find the stores that the brands are not in. Below is an example of the data i have:

Store Number	Brand
1	A
1	B
1	C
2	A
3	B

ultimately i would like to be able to select a brand via a slicer or graph, and have a table show me a list of stores that the selected brand is not in. For example if I filter on brand C it will tell me the stores it is not listed in is store 2 and 3.

I was thinking having a master table with a list of all the store numbers will help but I'm stumped from there.

Thank you in advance for any help!

[Wimverh · Accepted solution]

For a basic solution this dax should work:

# records anti = 
COUNTROWS (
    EXCEPT ( VALUES ( Brand[Brand] ), VALUES ( StoreBrandLink[Brand] ) )
)

 with a datamodel like this:

[camargos88]

Hi @matd13 ,

Check this file as an example: Download PBIX 

Ricardo