IFERROR + LOOKUPVALUE not returning false values

Hi jtam128 ,

According to your description, I create sample data to reproduce the scenario. Firstly, Create Many to one relationship between table Account Names and Bookings.

Then, create measure1 to judge return the true value or the false value. Assuming the false value is "D".

Measure1 = IF(ISBLANK(LOOKUPVALUE('Account Names'[Parent File Name],'Account Names'[Zuora Account Name],MAX('Bookings'[Account: Name]))),

MAX('Bookings'[Account: Name]),

LOOKUPVALUE('Account Names'[Parent File Name],'Account Names'[Zuora Account Name],MAX('Bookings'[Account: Name])))

Choose the table visual to display the result showing picture below.

Here is my test pbix file link: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EYu2tFaSZDRNuEWGe2tmhI4B3ZZsKw5jx_SZhzTc-w4lZQ?e=Tj687R

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.