Microsoft Power BI Cookbook

Bike only customers

1. Create a measure to compute the customers who've only make a bike purchase (not clothing or accessories)

Count of Bike Only Customers =  VAR BikeCustomers =   SUMMARIZE(CALCULATETABLE('Internet Sales','Product'[Product Category] = "Bikes"),  Customer[Customer Alternate Key]) VAR ClothesAndAccessoryCustomers =   SUMMARIZE(CALCULATETABLE('Internet Sales',  'Product'[Product Category] IN {"Accessories","Clothing"}), Customer[Customer Alternate Key])RETURNCALCULATE(DISTINCTCOUNT(Customer[Customer Alternate Key]), EXCEPT(BikeCustomers,ClothesAndAccessoryCustomers))

• The syntax aligns with the structure of the first measure except for the use of the IN DAX operator to include accessories and clothing in the same group of customer ...