Ignoring selections in AGGR

[mrmoster]

I am trying to work out query to select the latest month one of our offices had a new starter. After a bit of effort I managed to get the below to work, but I cant work how to get it to ignore when the month is selected on a filter or chart. 

Read similar posts but just cant seem to figure it out. Might be I have not worked out the best way to the find out the month. Any help would be much appreciated.  

max({$<Month>}Aggr(if(sum({$<[Data Collection Requirement]={"New Starters"},[Month]>} [All Count])>0,Month),Month))

[stevejoyce · Accepted solution]

This will fix your issue.  remember you'll need to ignore month in all references.

max({$<Month>}Aggr(if(sum({$<[Data Collection Requirement]={"New Starters"},[Month]>} [All Count])>0, only({<Month>} Month)),Month))

[mrmoster]

Thanks for the fix, knew I was missing out filter somewhere!