Return the max value of a slicer to a column

[Anonymous]

Hi there

I have a range of weeknumbers and use them in a slicer. I want to return the max value (and later the min value) of the slicer into a column to calculate the average based on the user selection.

Range of numbersReturn 40 and 46 to the column to calculate the average for these weeksReturn 40 and 43 to calculate the average of weeks 40-43

I tried to use SELECTEDVALUE but if multiple values are returned it shows blank. Is there a function I can use?

I hope I have described the problem well.

Big thanks in advance.

[Anonymous]

Thank you @Barthel

I expected, that this is not possible.

Best regards

[Barthel · Accepted solution]

Hey @Anonymous,

You can use the MAX function for the maximum and the MIN function for the minimum. However, a slicer has no effect on your tables, and therefore also not on calculated columns. A slicer only affects visuals and the measures you place in them.