Help with Measure and Parameter

[jdusek92]

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 · Accepted solution]

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]

Thanks @Jihwan_Kim 

Using == helped!