Distinct Count of Customers on Last Day

[ThePeterK]

Our qvd has one record per customer, per subscription. I'm trying to make a bar chart that represents the number of unique customers active at the end of each month/year (i.e. the max date in the group).

I can get a distinct count by month. I'm able to calculate the correct end date for each year via aggr(NODISTINCT max([Period Date]),[Fiscal Year]) , however that calculation is not working in the bar chart expression that drills down from fiscal year to period date. In the example, I want the value for Fiscal Year 2015-2016 to equal 43,167. Instead, it shows 56,543.

Here's the expression I've been working with/on, but I could really use some help:

count({<[Period Date]={'=aggr(NODISTINCT max([Period Date]),[Fiscal Year])'}>}distinct [Customer ID])

[Channa]

=Count({$<[Period Date]={"=MonthEnd(Today() ,0)"}>} distinct CustomerID)==end of current month