DAX Mesure

Hi Mario_Sam,

You can create the following DAX measure to correctly handle the rolling window and the current active condition:

Active Repeat Customers (90D) =
VAR MaxSelectedDate =
    MAX ( 'Date'[Date] )

VAR Recent90DaySales =
    CALCULATETABLE (
        Sales,
        DATESINPERIOD (
            'Date'[Date],
            MaxSelectedDate,
            -90,
            DAY
        )
    )

VAR RepeatCustomers =
    FILTER (
        SUMMARIZE (
            Recent90DaySales,
            Sales[CustomerID],
            "OrderCount", COUNTROWS ( Recent90DaySales )
        ),
        [OrderCount] >= 2
    )

VAR ActiveCustomers =
    CALCULATETABLE (
        VALUES ( Sales[CustomerID] ),
        KEEPFILTERS ( 'Date'[Date] )
    )

RETURN
COUNTROWS (
    INTERSECT ( RepeatCustomers, ActiveCustomers )
)