Calculated Column with LOOKUPVALUE only returns partial values

I’d like to acknowledge the valuable input provided by rajendraongole1. The initial idea was instrumental in guiding my approach.

Hi wbhite ,

Based on my testing, consider that it's because there are hidden characters in the Account# of the dim and fact tables.

You can use the EXACT function to compare the two texts to see if they are identical, and if so, return the Account Name and then make adjustments.

Account Name1 = 
IF(
    EXACT(
        'Fact'[Account #], 
        LOOKUPVALUE('Dim'[Account #], 'Dim'[Account #], 'Fact'[Account #])
    ),
    LOOKUPVALUE('Dim'[Account Name], 'Dim'[Account #], 'Fact'[Account #]),
    "null"
)

A comparison of the two measures is as follows:

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!