Lookup value instead of a where the item is not found a blank a zero

[Anonymous]

Im doing lookup between different filess and as part of that I would like to return the value 0 if an item is not found.

Example of current formula

Personal FY21 = LOOKUPVALUE('PersonalFY21'[Total Units],'PersonalFY21'[Number],'Taken'[Number])

This works fine but if it possible to return a zero where an item is not found.

[amitchandak · Accepted solution]

@Anonymous , Try

Personal FY21 = LOOKUPVALUE('PersonalFY21'[Total Units],'PersonalFY21'[Number],'Taken'[Number]) +0

or

Personal FY21 = Maxx(filter('PersonalFY21', 'PersonalFY21'[Number]= 'Taken'[Number]),'PersonalFY21'[Total Units])+0