Forum Discussion
USERELATIONSHIP doesn't work
I need a simple USERELATIONSHIP formula to work and I have no idea why it doesn't. Please find an example here: report There are 2 tables with one active and one non-active relationship. I've ...
Anonymous
Tricky. You could do something like this:
CALCULATION = CALCULATE ( CALCULATE ( DISTINCT ( 'DIM Rooms'[Used for] ), 'Room data' ), USERELATIONSHIP ( 'Room data'[Room # ADJUSTED], 'DIM Rooms'[Room only] ), ALL ( 'DIM Rooms' ) )but it's quite complex. Best use LOOKUPVALUE:
CALCULATION V2 = LOOKUPVALUE( 'DIM Rooms'[Used for] , 'DIM Rooms'[Room only], 'Room data'[Room # ADJUSTED])Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi Anonymous
The link for the file requires logging into google. Can you remove the requirement? Or host the file somewhere else?
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
I am really sorry about that. I removed any restrictions. It should work now.