Forum Discussion
ignore all selection
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
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]))