Forum Discussion
Solved
Trouble using DAX to calculate properly between multiple active/inactive relationships
Hello, I'm trying to understand if leveraging the Power BI relationships is a good place to do this, or if it's better suited to something like Power Query, or if we just write a database query t...
Closing the loop in case anyone comes across this thread with a similar issue. I ended up solving the in-app problem by making all of the relationships for people names inactive. This made the LOOKUP formula return proper results.
Closing the loop in case anyone comes across this thread with a similar issue. I ended up solving the in-app problem by making all of the relationships for people names inactive. This made the LOOKUP formula return proper results.