So I have this calculated column where I am using the LOOKUPVALUE formula to bring the record field text to another table (pretty basic). It was working fine, but suddenly now the calculated column is empty. I have not changed the formula and both columns are Text format. One for the data source is a salesforce object and another is an excel file.
i cannot understand what could be going on! I tried doing other lookupvalue formulas with other columns to test and they are not working either.
So I found the issue! I brought in a new data source (table called New Writer Master below) and when i created the relationship with my master Territories table I didnt noticed that it defaulted to Cross filter direction both. Once I changed this to single it worked again!
Thanks Vivran, your comment sparked the idea to look there.
So I found the issue! I brought in a new data source (table called New Writer Master below) and when i created the relationship with my master Territories table I didnt noticed that it defaulted to Cross filter direction both. Once I changed this to single it worked again!
Thanks Vivran, your comment sparked the idea to look there.
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
