How to get selected from Range filter

[MarshalSK]

Hi Folks, Need help to get user entered value from range filter

[Uzi2019 · Accepted solution]

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.

[Anonymous · Accepted solution]

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.

[Uzi2019 · Accepted solution]

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.

[MarshalSK]

@Uzi2019  Thanks but above result will not satisfy the requirement, can you please make use of the sample data which i shared.