Forum Discussion

amaniramahi's avatar
amaniramahi
Helper V
5 years ago
Solved

Between slicer threshold

How to get the minimum and maximum value for slicer (type between).

 

The slicer is for a column with numbers data type.

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    amaniramahi , Please try like these

     

    measure 1=
    VAR _min = MINX( allselected('Table') , 'Table'[Value] ) // Value in slicer
    VAR _max = MAXX(allselected('Table') , 'Table'[Value] ) // Value in slicer 

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    amaniramahi , Please try like these

     

    measure 1=
    VAR _min = MINX( allselected('Table') , 'Table'[Value] ) // Value in slicer
    VAR _max = MAXX(allselected('Table') , 'Table'[Value] ) // Value in slicer