LookupValue Loop question

[gmazza76]

Good afternoon,

I have a formula in DAX for Power Pivot that is working, but I want to be able to look by including an if()
Formula 1 works great, but instead of having multiple columns I want to be able to change the Criteria for check[Search1] to a formula, but I cant get the Formula 2 to work without a "list of Multiple values was supplied where a single value was expected"

Formula 1
LOOKUPVALUE(Source[Title],Source[Search1.1],'check'[Search 1.1],Source[CAllRank],"1",Source[Date],check[Date],Source[Call Outcome],"Success")))))

Formula 2
if(LOOKUPVALUE(Source[Title],Source[Search1.1],'check'[Search 1.1],Source[CallRank],"1",Source[Date],check[Date],Source[Call Outcome],"Success")>blank(),
LOOKUPVALUE(Source[Title],Source[Search1.1],'check'[Search 1.1],Source[CallRank],"1",Source[Date],check[Date],Source[Call Outcome],"Success",

thanks in advance.
Gavin

 

[jorismoerings]

Hi,

Just for clarity are you sure you've copied the full formula 2?
Reason for asking it lacks closing parentheses.
After "Success" is a comma as closure for the LOOKUPVALUE function which should be a parentheses and a second one is lacking for closure of the IF THEN part

So try this instead of your formula 2 and see if this olves the issue.

if(LOOKUPVALUE(Source[Title],Source[Search1.1],'check'[Search 1.1],Source[CallRank],"1",Source[Date],check[Date],Source[Call Outcome],"Success")>blank(),
LOOKUPVALUE(Source[Title],Source[Search1.1],'check'[Search 1.1],Source[CallRank],"1",Source[Date],check[Date],Source[Call Outcome],"Success"))

 

[gmazza76]

Good morning @jorismoerings

I have tried the amendments to the formula as per above, and I still get the same error message of multiple tables.
If I just the 1st line without if part it works so I dont understand where the multiple table part comes from?

thanks

 

[jorismoerings]

There are other solutions to get to this result as well however with this little information to go on, the guessing part increases exponentially.
Could you drop a testfile (without sensitive data of course) in public fileshare so i can take a look.

 

[gmazza76]

I will see what I can pull together, what others ways would you suggest using as I hadn't really looked at anything else?