how to calculate customer at risk

[sgintowt]

Hello

I need to calculate customers who had no sales for 30 to 180 days.Have any of you counted customers in a similar way?
I tried with measure but it doesn't count correctly.

Lost Customers  =

    VAR CustomersList = DISTINCT(AccountsPerformanceReports[MckAccountId])

    VAR ChurnDate = 30

    RETURN

        COUNTROWS(

                FILTER(

                    CustomersList,

                    CALCULATE( COUNTROWS(AccountsPerformanceReports),

                    FILTER( ALL(Dates),

                    Dates[Date] > (MIN (Dates[Date]) - ChurnDate) && Dates[Date] < MIN(Dates[Date]))) = 0 ))

Please help

[amitchandak · Accepted solution]

@sgintowt , First create a meausre like

Rolling 30 to 180 = CALCULATE(Average(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ])-30,-150,DAY))

Then create a new measure

Risk customer =

countx(values(customer[customer]), if(isblank([Rolling 30 to 180]), [Customer], blank()) )

same as lost customer logic

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...