ignore all selection

[alihijazi]

Hello

I'm trying to create a measure that is the max year available i.e. 2016

I want this measurue to display 2016 no matter what the user selects as filter 

please advise

[Greg_Deckler]

Use an ALL clause in your FILTER statement:

https://msdn.microsoft.com/en-us/library/ee634802.aspx

So, something like:

MAXX(ALL([Table]),[Column])

or

CALCULATE(MAX([Column]),ALL([Table]))