Forum Discussion

jdusek92's avatar
jdusek92
Icon for Advocate III rankAdvocate III
5 years ago
Solved

Help with Measure and Parameter

Hello! I am trying to achieve a dynamic value using a parameter. I have a table with a column "days to fill", I want to create a measure that would return "OK" or "NOT OK" based on parameter value ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, jdusek92 

    Please try the below.

    I think the value zero is also considered as a blank.

    In order to prevent 0 from becoming a blank, please put == instead =

     

    Is OK =
    IF (
    SELECTEDVALUE ( 'Application'[DaysToFill] ) == BLANK (),
    BLANK (),
    IF (
    SELECTEDVALUE ( 'Application'[DaysToFill] ) <= DaysToFill_OK[DaysToFill_OK_value],
    "OK",
    "NOT OK"
    )
    )

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, jdusek92 

Please try the below.

I think the value zero is also considered as a blank.

In order to prevent 0 from becoming a blank, please put == instead =

 

Is OK =
IF (
SELECTEDVALUE ( 'Application'[DaysToFill] ) == BLANK (),
BLANK (),
IF (
SELECTEDVALUE ( 'Application'[DaysToFill] ) <= DaysToFill_OK[DaysToFill_OK_value],
"OK",
"NOT OK"
)
)

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

  • jdusek92's avatar
    jdusek92
    Icon for Advocate III rankAdvocate III
    5 years ago

    Thanks Jihwan_Kim 

    Using == helped!