Use the coalesce function for calculated fields in Amazon QuickSight.