Count a store selling all products

[Anonymous]

I want to count a store if it carries all 7 SKUs.  But if a store does not carry all 7 SKUs I do not want to count it.  As an example, customer is on the left and the skus are each column.  I would want to count 3 as only 3 customers carry all 7 skus even though there are 4 stores.

[Icey]

Hi @Anonymous ,

What is the structure of your data in Power BI Desktop? 

Best Regards,

Icey

[amitchandak]

@Anonymous , Try this

Count of store sell all 7 SKU

Count of Store = countx(filter(Summarize(Table[Store], "_1",DISTINCTCOUNT(Table2[SKU])),[_1]>=7),[Store])

[mahoneypat]

If not already, you should unpivot your SKU columns to simplify your DAX analysis.  If all SKUs are in same column,you could use an approach like this

Stores Selling All SKUs = COUNTROWS(FILTER(DISTINCT(Table[Store]), CALCULATE(DISTINCTCOUNT(Table2[SKU])) = 7))

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat