Forum Discussion

linlab's avatar
linlab
Regular Visitor
5 years ago

DAX expression for a numeric range slicer

Hello, I've selected the column month to work as a numeric range slicer. Is there any DAX expression to get the 2 values introduced in the slicer? I've tried MIN and MAX with SELECTEDVALUE but is no...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

linlab , You can use MinX/MaxX

 

measure =
var _max = maxx(ALLSELECTED('Date'),'Date'[Month])
var _min = minx(ALLSELECTED('Date'),'Date'[Month])
return
calculate(countrows(Table), filter(Date, Date[Month] >=Min && 'Date'[Month] <=Max ))