Forum Discussion

amiller5's avatar
amiller5
Icon for Helper II rankHelper II
4 years ago
Solved

Returning a value from a lookup value formula

I have 2 different files - they are connected in relationships by Account name but there may be multiple account names in the "Service 3 - Opps" file.  This is the column measure I have started:  ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Try this

    =if(isblank(LOOKUPVALUE('Service 3 - Contract Opps'[Account Name],'Service 3 - Contract Opps'[Account Name], 'Service 4 - Contract accts'[Account Name])),0,1)

    Hope this helps.

amiller5's avatar
amiller5
Icon for Helper II rankHelper II
4 years ago

This also brings in the account name when the Iferror expression with the lookup is true. I want it to bring in a 1.0 value

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
4 years ago

amiller5 

pls try this

IF ( ISBLANK(LOOKUPVALUE (
'Service 3 - Contract Opps'[Account Name],
'Service 4 - Contract accts'[Account Name], 'Service 4 - Contract accts'[Account Name])),0,1)