Creating an if measure only for rows that are not null

[drogzy]

Hi all, 

I am trying to create an if measure only for rows that are not blank, here is where I am stuck. 

if(selectedvalue(Table1[value])= ISNOTNULL then (selectedvalue(Table2[contractor])) else null 

The bold part is where I am not sure how to label, is there a way to only reference rows that are not null?

[tackytechtom · Accepted solution]

Hi @drogzy ,

Do you mean something like this?

if ( selectedvalue(Table1[value]) <> BLANK(), selectedvalue(Table2[contractor], BLANKU() )

let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/