cancel
Showing results for
Did you mean:
Helper III

## 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

1 ACCEPTED SOLUTION
Super User

Hi, @jdusek92

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.

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

2 REPLIES 2
Super User

Hi, @jdusek92

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.

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

Helper III

Thanks @Jihwan_Kim

Using == helped!

Announcements

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

#### What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.