Forum Discussion
Solved
Finding Brands Missing From Stores
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 Numb...
For a basic solution this dax should work:
# records anti = COUNTROWS ( EXCEPT ( VALUES ( Brand[Brand] ), VALUES ( StoreBrandLink[Brand] ) ) )with a datamodel like this:
Wimverh
Resolver IV
Resolver IVFor a basic solution this dax should work:
# records anti =
COUNTROWS (
EXCEPT ( VALUES ( Brand[Brand] ), VALUES ( StoreBrandLink[Brand] ) )
) with a datamodel like this: