Finding Brands Missing From Stores

Question

Hello Experts:&nbsp;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:&nbsp;Store NumberBrand1A1B1C2A3B&nbsp;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.&nbsp;I was thinking having a master table with a list of all the store numbers will help but I'm stumped from there.&nbsp;Thank you in advance for any help!

wimverh · Accepted Answer

For a basic solution this dax should work:# records anti = 
COUNTROWS (
    EXCEPT ( VALUES ( Brand[Brand] ), VALUES ( StoreBrandLink[Brand] ) )
)&nbsp;with a datamodel like this:

Forum Discussion

Finding Brands Missing From Stores

2 Replies

Related content

Find missing data

missing data

Finding DISTINCT COUNT of Brands by Country

missing data

Generating Missing Data

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