To clarify, I’m trying to adapt the formula below for churned customers into something that would calculate total spend. I tried substituting the [Unique Customers] variable with a variable called Total Spend = SUM(Orders[total]), but that did not work. Any clues?
Churned Customers =
VAR CustomerDimension = VALUES( Customers[Customer Names] )
IF( SELECTEDVALUE( ‘Cohort Periods’[Period] ) = 0, [Unique Customers],
CALCULATE( [Unique Customers],
FILTER( ‘Cohort Periods’,
[Retention Days] > ‘Cohort Periods’[Min Days] && [Retention Days] <= ‘Cohort Periods’[Max Days] ) ) > 0 ) ) )
//main churning formula