DAX IF formula for 'numeric range paramater'

Hi mheagerty 

The HotChilli advice is sound.

If you want 'Table'[Column] to output values based on the slicer's selection, you should use Measure, not Column.

And your slicer is a range, which is why your dax doesn't work.

You can extract values from the slicer, such as minimum values:

Create a measure.

Test = 
var _parameter = MIN('Parameter'[Parameter Value])
var _column = SELECTEDVALUE('Table'[Column])
RETURN 
IF(_parameter < _column, "True", "False")

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.