Second Last Transaction Date without filters

Hi,

I work at a nonprofit with specific KPIs for donors based on the length of time between their two previous donations. We categorize donors in the following ways:

1. Active donors: last transaction date is within 18 months of the last day in the reporting period
2. Lapsed donors: last transaction date is 18-36 months prior to the last day in the reporting period
3. Lost donors: last transaction date > 36 months prior to the last day in the reporting period

Within the set of active donors, there are four mutually exclusive groups:

1. New donor: undefined/infinite amount of time between the last two gifts (transactions)
2. Retained donor: < 18 months between last two transactions
3. Reactivated from lapsed: 18 - 36 months between last two transactions
4. Reactivated from lost: >= 36 months between last two transactions.

There is a customer (donor) dimension table and a transaction (donations) fact table that are related via a numeric customer id.

Based on this thread I've tried the following as a measure on the Customer (donor) table:

Second Last Transaction Date = 
VAR 
    LastTransDate = MAX(Transactions[transaction_date])
RETURN
    CALCULATE(
        MAX(Transactions[transaction_date]),
        FILTER(Transactions[transaction_date] < LastTransDate)
    )

This works as expected as long as no filters are applied at the report, page, or visual level. The next thing I tried was adding ALL(Transactions), which I quickly realized gets all the transactions (including ones not related to the particular row's customer). I also tried FILTER( ALL( Transactions [ customer_id ], Transactions [ customer_id ] = Customers [ customer_id ] ), But that didn't work either.

I think I need to find a way to get all transactions for each donor without any filters applied, but I can't quite figure out how.

Ultimately, I'd like to be able to use these categories (new, retained, reactivated lasped, reactivated lost) as dimensions for other visualizations (e.g. # of reactivated lapsed donors per year for the last 5 years).