Counting Active in non calendar date range

Hi MarionC ,

Your solution is great, audreygerred . Here I have another idea that I want to share for reference.

You can create a measure to count users.

Active Accounts =
CALCULATE(
COUNTROWS('USER'),
FILTER(
'USER',
'USER'[Creation Date] <= MAX('BILLING'[End Date]) &&
(ISBLANK('USER'[Expiry Date]) || 'USER'[Expiry Date] >= MIN('BILLING'[Start Date]))
)
)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.