Forum Discussion
Solved
Nearest Value of Selected Measure
I have a requirement where I will select a number from slicer and from data-set I need to look out a specific column based on slicer selected. If selected value is exactly matching with lookup value,...
hegde86 try following measure
Nearest Value Lower = VAR __selectedSlicerValue = SELECTEDVALUE( SlicerTable[Column] ) RETURN CALCULATE( MAX( YourTable[Qty] ), YourTable[Qty] <= __selectedSlicerValue ) Nearest Value Upper = VAR __selectedSlicerValue = SELECTEDVALUE( SlicerTable[Column] ) RETURN CALCULATE( MIN( YourTable[Qty] ), YourTable[Qty] >= __selectedSlicerValue )
hegde86 try following measure
Nearest Value Lower = VAR __selectedSlicerValue = SELECTEDVALUE( SlicerTable[Column] ) RETURN CALCULATE( MAX( YourTable[Qty] ), YourTable[Qty] <= __selectedSlicerValue ) Nearest Value Upper = VAR __selectedSlicerValue = SELECTEDVALUE( SlicerTable[Column] ) RETURN CALCULATE( MIN( YourTable[Qty] ), YourTable[Qty] >= __selectedSlicerValue )
