Lost customers
Hi I try to calculate the lost customers over time in a specific week. I feel like I am almost there but cannot get it to work. I am for sure overseeing something in the measure, hopefully you can help. The assumption used it that all customers who have a last sale older than 12 weeks should be considered lost. The measure should be able to present the lost customer in a stack column chart but also show which customers are lost in a matrix table when selecting the period in the chart. # lost customers week = var SelectedWeek = SELECTEDVALUE('FS_Vertaling weken naar perioden'[Index - week]) var allcustomers = values(FS_Omzet_uren_all[Groepnaam]) --take all customers var customerinactiveperiod = CALCULATETABLE( values(FS_Omzet_uren_all[Groepnaam]), --select all customers who match below filter filter( all( 'FS_Vertaling weken naar perioden'), --remove all date filters 'FS_Vertaling weken naar perioden'[Index - week] > SelectedWeek-12 && 'FS_Vertaling weken naar perioden'[Index - week] < SelectedWeek)) --take all customers with sales in the last 12 weeks return COUNTROWS( EXCEPT(allcustomers,customerinactiveperiod)) --take all customers and remove all active customers (customers in active period) This is what I get: This is what I would expect:
Help with 'New Business, 'Returning Business' and 'Lost Business' DAX Calculations
Hi Community This one has baffled me for a while now. I'm trying to come up with the right method and DAX for calculating the following: New Business - Total Sales Amount on an Item & Customer combination that sells for the first time in a rolling 12 month period. Returning Business - Total Sales Amount in 24 months on Item & Customer combination that has ordered in the previous 12 months and has prior 12 months. Lost Business - Total Sales Amount for Item and Customer comination that hasn't ordered in 12 months but has in prior 12 months. I have a date table at the ready, and all of my Sales Data is in one table. So the model is very simple. I'm using SSAS Tabular Live Connection, so any changes would be back end. Any other posts I've found online are looking at number of customers, and aren't specific to 'Item and Customer' combination. Appreciate your help. Thanks Martin
