cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver I

## How to get selected from Range filter

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

2 ACCEPTED SOLUTIONS
Super User

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.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Community Support

Hi @MarshalSK ,

The table data are as follows:

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.

3 REPLIES 3
Community Support

Hi @MarshalSK ,

The table data are as follows:

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.

Super User

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.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Resolver I

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.