
1. Re: Find Sum of Sales with Consumers of a specific Market Basket
Galen Busch Jul 5, 2018 11:48 AM (in response to Brandon Storey)Hi Brandon,
A market basket analysis is what you're looking for. The best tutorial is here:
Workout Wednesday: Market Basket Analysis
The limitation with this method, is that you'll be confined to 2 combinations  A & B, not A & B & C
Due to your relatively low number of members of your dimension, I'm afraid the best way to get there may be through a series of calculations.
{FIXED [Customer ID] : max(if [Product] = 'A' then 1 else 0 end)} //1 if customer every purchased product, else 0
{FIXED [Customer ID] : max(if [Product] = 'B' then 1 else 0 end)} //1 if customer every purchased product, else 0
{FIXED [Customer ID] : max(if [Product] = 'C' then 1 else 0 end)} //1 if customer every purchased product, else 0
{FIXED [Customer ID] : max(if [Product] = 'D' then 1 else 0 end)} //1 if customer every purchased product, else 0
You can then create ((many)) calculations from this.
if [Calc A] = 1 and [Calc B] = 1 then [Customer ID] end "A & B purchased"
if [Calc A] = 1 and [Calc B] = 1 and [Calc C] = 1 then [Customer ID] end "A & B & C purchased"

2. Re: Find Sum of Sales with Consumers of a specific Market Basket
Galen Busch Jul 5, 2018 11:49 AM (in response to Brandon Storey)Alternatively, you could simply bring each of these 4 calculations to the filters shelf, and use these filters for specific combinations.