Forum Discussion

Dave_Gugg's avatar
Dave_Gugg
Icon for Kudo Collector rankKudo Collector
9 years ago

DAX - Customer Rebuy/Gateway Analysis

I am trying to get a percentage of customers who rebuy based on the initial product purchased.  I have a standard fact/dimension data warehouse with a Order Placed fact, a Customer dimension, and a P...
Need Help
Dave_Gugg's avatar
Dave_Gugg
Icon for Kudo Collector rankKudo Collector
9 years ago

I was able to find a formula that gives me the correct answer, but it runs into the 1M row limit unless I filter on the product subcategory.  This is the formula:

Rebuyer Count = COUNTROWS(INTERSECT(SUMMARIZE(FILTER(Demand,Demand[Customer Order Sequence Number] = 1),[CustomerKey]),SUMMARIZE(CALCULATETABLE(FILTER(Demand,Demand[Customer Order Sequence Number] = 2),all('Product')),[CustomerKey])))

Can anyone help me refine this formula so it works for my full data set?