How to get selected from Range filter

Hi MarshalSK 
You have to create seperte measures for Min and Max.

Min = CALCULATE(MIN(Table[Clicks]), ALLSELECTED(Table))

Max = CALCULATE(Max(Table[Clicks]), ALLSELECTED(Table))

and you can switch value to rows instead of columns. by changing the settinf of Values > Option>

 

 

I hope I naswered your question.

Hi Uzi2019 ,Thanks for the quick reply, I'll add to it.

Hi MarshalSK ,

The table data are as follows:

Please follow these steps:
1. Use the following DAX expression to create a table

Table 2 = GENERATESERIES(1,100,1)

2. Relate the two tables

3. Use the following DAX expression to create a measure named ‘Max’

Max = SELECTEDVALUE('Table 2'[Value],MAXX('Table 2',[Value]))

4. Use the following DAX expression to create a measure ‘Min’

Min = SELECTEDVALUE('Table 2'[Value],MINX('Table 2',[Value]))

5. Final output

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.