cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jdusek92
Helper III
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"))

jdusek92_1-1621287833662.png

 

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

 

Warm regards

Jakub

 

 

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

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


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.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

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


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.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

View solution in original post

Thanks @Jihwan_Kim 

Using == helped!

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors