The formula GetFieldSelections() results in a string with the selected values of a field.
The field within a filter pane, in this example field [Year]
The seperator to use between the selected values, in this example a comma (',')
The maximum number of values that may be added in the string. To add all the selected values to the string, you can use GetSelectedCount() formula. This is the number of selected values of a field. If you select one year, the result of the formula GetSelectedCount([Year]) is 1, if you select two years, the result will be 2, if you select all years, the result will be 10.
The next formula that is needed to determine the minimum value of all the selected values is SubField(). This is a formula to get one value in a string of values seperated by a specific seperator.
The text expression for this example is a string with all selected values: GetFieldSelections([Year],',',GetSelectedCount([Year]))
Use the same delimiter as the value_seperator, in this example use comma (',')
To retrieve the first selected value, use number 1.
4. Add a formula on dimension for the maximum selected year
Add the following formula to determine the maximum value of the selected year: