Dynamic USERELATIONSHIP

[georgecrowley]

Hello!

Aiming to create some sort of DAX code where I use a Field parameter and filter - doing this will change which relationship will become active between two tables.

ie 

Proposed Sales (Value 1) = CALCULATE(IFERROR([Proposed NCR (Value 1)]*[NB QUOTES],0),USERELATIONSHIP(ALL('NB Code'),ALL('Sharepoint List')))

something along these lines!

[Greg_Deckler]

@georgecrowley Try something like this. I'm not exactly certain what you are trying to do without sharing sample data and more information.

Proposed Sales (Value 1) =
  VAR __ValueError = IFERROR([Proposed NCR (Value 1)]*[NB QUOTES],0)
  VAR __Result =
    IF(__ValueError = 0,
      CALCULATE([Proposed NCR (Value 1)]*[NB QUOTES],0),USERELATIONSHIP('NB Code'[Column], 'Sharepoint List'[Column])),
      __ValueError
    )
RETURN
  __Result

[Greg_Deckler]

@georgecrowley You might find this thread interesting. Solved: Re: No CACULATE challenge - Microsoft Power BI Community