Forum Discussion

jdusek92's avatar
jdusek92
Advocate 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 and the actual "days to fill" number.

 

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

 

I am wondering why am I getting Blank values for zeros?

 

Warm regards

Jakub

 

 

  • 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

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super 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