Forum Discussion
MarshalSK
Resolver I
2 years agoHow to get selected from Range filter
Hi Folks, Need help to get user entered value from range filter
Anonymous
2 years agoNot applicable
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.