Set analysis, get maximum applicable to ALL selected dimensions

[Anonymous]

Hi!

I am using the following (simplified) function:

SUM({<[USE_Reporting month] = {"$(=max([USE_Reporting month]))"}>*<[Data complete]={1}>},[USE.Quantity])

I have a filter dimension on 'country', and the condition 'Data complete = 1' is different per country (e.g. for some countries we have data complete up to august, for others only until june). I want this function to give me the latest (MAX) month where 'Cumulative to date = 1 applies to all selected countries. How do I do this?

Thanks a lot!