Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dynamic USERELATIONSHIP

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 Sal...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous 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