Overall MAX()-Value which ignores the context

[Salfii]

Hi,

is there any way to extract an overall MAX()-Value of a dimension which ignores any context (Row-Context for example)?

I´m currently trying to achieve some YTD - PY Comparison, but not just for Year(today()), it should be the Max present year in the data or the maximum selected year. Therefore, I need to extract the Maximum Year without context.

Currently there´s a problem with citys (or other dimensions) which don´t have values for the maxium present year (2017 in this case):

The formular I´m using fot PAX YTD is:

PAX YTD = 
CALCULATE(
SUM(TrafficData[PAX]);
    FILTER(
        ALL('#L_LinkTable'[Year]);
        VALUE('#L_LinkTable'[Year]) = VALUE(MAX('#L_LinkTable'[Year]))
    )
)

The year in this case, should always use the overall maximum year (or selected maxium year) and ignore the row context of "Aachen", is this possible?

Thanks in advance.

Best regards.

[v-chuncz-msft]

@Salfii,

You may try to use ALLSELECTED Function.