Using Parameter value in an If Statement on Column

[Alpesh]

Hi

I have a slicer with 1 - 1000. I want to use the value from this slicer (Parameter created number range created) in an If statement to check if a column on the table is above a certain value. However, it does not seem to work...

Here is the DAX:

_custom Is Case within SLA? =

VAR SLA = Parameter[Parameter Value]

rETURN

IF(ISBLANK('Chat Table Unique'[Accepted Time]), "No Accepted Time", IF([_1st Accepted Bus. Seconds] < SLA, "True", "False"))

However, if I "hard code" the variable with a number it works fine... how can I get it to be dynamic based on the slicer selection?

VAR SLA = 200

rETURN

IF(ISBLANK('Chat Table Unique'[Accepted Time]), "No Accepted Time", IF([_1st Accepted Bus. Seconds] < SLA, "True", "False"))

[Anonymous · Accepted solution]

Hi @Alpesh ,

Please try this measure:

_custom Is Case within SLA? =

VAR SLA = SELECTEDVALUE('Parameter'[Parameter])
RETURN
IF(ISBLANK('Chat Table Unique'[Accepted Time]), "No Accepted Time", IF([_1st Accepted Bus. Seconds] < SLA, "True", "False"))

Best Regards,

Neeko Tang

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