Forum Discussion
More USERELATIONSHIP Problems adding a drill through table
I am starting to think that attempting to USE USERELATIONSHIP for a none active join is a bad idea because im constantly hitting problems. Looking at the following example again
So this ...
Hi DebbieE
You're correct that USERELATIONSHIP can get rather complex, depending on your goals. Not sure if this what you're looking for, but here's an in-depth write up with vid by Alberto Ferrari that recently helped me understand it better: https://www.sqlbi.com/articles/userelationship-in-calculated-columns/ . You might be interested in the end where he uses LOOKUPVALUE to make what was complex rather simple.
Hope that helps
James
Fabulous. thank you so much.
Hopefully it mentions slicers and drill throughs because this was the point where I gave up and chose multiple role playing tables.