Latest Enterprise DNA Initiatives

Total Sales and Average spend

Hello!

I am trying to figure out Sales that came from new customers that enrolled and placed orders in a cycle . Once I have that, I can create measures to see the % of sales that come from the new customers vs total sales, Average spend, etc.

Attached is the sample file and any help with this is really appreciated. Retention with Sales.pbix (7.0 MB)

Thanks,
Nipuna

Hi @nipunadv,

For this type of calculation you can resuse the new customer count pattern, it just requires a small modification as you can see in the example below.

Sales C+01 = 
VAR FirstCycle = MINX( ALLSELECTED( CALENDAR[CycleID] ), [CycleID] )
VAR _Cycle = MAX( CALENDAR[CycleID] )
VAR FirstCust =
    CALCULATETABLE( 
        VALUES( CUSTOMERS[CustomerID] ), 
        TREATAS( VALUES( CALENDAR[PeriodID] ), CUSTOMERS[EntryPeriodID] ),
        CALENDAR[CycleID] = FirstCycle
    )
VAR CustOrders = 
    CALCULATETABLE( 
        VALUES( SALES[CustomerID] ), 
        CALENDAR[CycleID] = _Cycle +1,
        ALL( CALENDAR[CycleText] )
    )
VAR NewCustomers = INTERSECT( FirstCust, CustOrders )
RETURN

CALCULATE( [Sales],
    NewCustomers
) 

.

I hope this is helpful.