Avoiding filtered context with Variable. Help needed

Hello amitchandak,

thanks.  Highly appreciated your effort. My question is not so much going into the direction how to achieve to show certain numbers, but more fundamental. How to avoid, that my attempt to filter for the max date of actual version is not going to pass on a filter context only showing actual numbers.

Possible that my entire approach is not very efficient, but I want to go live with V1 next week and this seems to be the remaining hurdle to increase the user experience (or rather avoid user confusion)

By replacing the MaxDate at the very bottom with a hard coded date I get exactly what I want. So I assume that my way of extracting the date is wrong or I need to add something to the final calculate formula to eliminate the filter context generated with my variable

All Values Cons MaxDate =
  VAR DateMax =
    CALCULATE(
      MAXX(
         FactFIRE,
         FactFIRE[Period ID]
      ),
      FactFIRE[Version ID]=2
   )
   RETURN

CALCULATE(
   [All Values Uncons],
   FILTER(
      FactFIRE,
         not(
            CONTAINS(
               DimHierarchy,
               DimHierarchy[CPOC],
               FactFIRE[PCPOC]
            )
         )
      ),
      FactFIRE[Period ID]<=DateMax
)+0