0

I have a table where each row is a product sold in a store. A product has two relevant columns, EAN and Store. How do I find all products (that have the same EAN) that appear in all Stores? For example, if Store A has products with EANs 1, 2 and 3, Store B has 2, 3 and 4 and Store C has 2, 3 and 5 (9 rows in total), how can I get all rows where EAN is 2 or 3 (6 rows in total)?

Thanks in advance!

Nanofus
  • 7
  • 2

1 Answers1

0

Add a calculated column to your model, then use this as a filter. 

=calculate(counta(product[EAN]),filter(all(product),product[EAN] = EARLIER(product[EAN])))

Screenshot of solution

You can then use this value to compare with Total number of stores. For this you can use the distinctcount measure.

WimV
  • 1,005
  • 6
  • 11