DAX column using LOOKUPVALUE - what if the value isn't there?

[grggmrtn]

I have the following calculated column, and it works fine(ish):

Column =
IF (
    'citizen'[Source] = "1.1",
    LOOKUPVALUE ( 'citizen2'[Other Source], 'citizen2'[id], 'citizen'[id] ),
    "no"
)

But now I've run into the situation where 'citizen2'[id] doesn't exist, so I get "" as a result. How can I insert another IF statement that will output "1.1.1" if Source = "1.1" and the LOOKUPVALUE is ""?

[amitchandak · Accepted solution]

@grggmrtn , not very clear, try with switch-like

Column =
Switch (true() ,
LOOKUPVALUE ( 'citizen2'[Other Source], 'citizen2'[id], 'citizen'[id] ) = "1.1.1", "<>" ,
'citizen'[Source] = "1.1", LOOKUPVALUE ( 'citizen2'[Other Source], 'citizen2'[id], 'citizen'[id] ),
"no"
)

[grggmrtn]

Thanks @amitchandak that worked great - I just had to switch your code up a bit:

Column =
Switch (true() ,
LOOKUPVALUE ( 'citizen2'[Other Source], 'citizen2'[id], 'citizen'[id] ) = "", "1.1.1" ,
'citizen'[Source] = "1.1", LOOKUPVALUE ( 'citizen2'[Other Source], 'citizen2'[id], 'citizen'[id] ),
"no"
)

It does just what I need 🙂