topic Re: Lookup value instead of a where the item is not found a blank a zero in DAX Commands and Tips

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

Anonymous — Thu, 03 Mar 2022 05:14:38 GMT

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 — Thu, 03 Mar 2022 05:48:23 GMT

Anonymous , Try

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

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