Count measure does not display all values

Hi there,

I have two tables: date and Authorisation. The authorization table contains the information about the individual and its practice certificate start and expiry date. I have created a measure that counts the valid authorization ids. Valid authorization means those authorizations whose expiry date is in the current financial year or upcoming ones (not in previous financial years) and start date of the authorization should not be starting in upcoming financial years.  I want to display the measure in a line graph where the x-axis contains the financial years. My measure is as follow:

Count Authorisation FY = CALCULATE(COUNT('ECR Authorisation'[AuthorisationID]),FILTER(dates,Dates[FiscalYearOffset] <=0))

 

When I displayed the above measure, it looks like as follow:

 

The problem with above measure is that it does not display the total of authorization ids which are valid each financial year. It only shows the count of authorisation that will be expired in that particular year. could anyone help me where I made the mistake?

 

Sample file here