Customer Activation calculation

I think I understand what you are trying to achieve, but I could really use some sample data to test my idea. 

Roughly: I am thinking of creating a measure that does it all in once by:
1. _curContext = Creating a variable that holds the current selected timeframe of subscribers (basically, the current context of Subscriber table)
2. _addedColumn = Create a second variable by adding a column in the first table variable, that looks if the first transaction of current row subscriber is within MAX(subscriber[date]) and MIN(subscriber[date]) and returns true if that is the case, and false when that is not the case
3. return the DIVIDE(COUNTROWS(FILTER(_addedColumn, [addedColumn] = TRUE)), COUNTROWS(_curContext))

When adding this into a context filtered by month (e.g. a matrix or a table), this would give you your activation 🙂 But without the table structure and column names I can't produce any DAX for you now, but maybe this is help enough already? Let me know! 🙂

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂