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 Sales (Value 1) = CALCULATE(IFERROR([Proposed NCR (Value 1)]*[NB QUOTES],0),USERELATIONSHIP(ALL('NB Code'),ALL('Sharepoint List')))
 
something along these lines!

2 Replies

  • 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