topic Re: Dynamic USERELATIONSHIP in DAX Commands and Tips

Dynamic USERELATIONSHIP

Anonymous — Fri, 24 Mar 2023 15:50:04 GMT

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.

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

something along these lines!

Re: Dynamic USERELATIONSHIP

Greg_Deckler — Fri, 24 Mar 2023 16:30:22 GMT

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

Re: Dynamic USERELATIONSHIP

Greg_Deckler — Fri, 24 Mar 2023 16:49:32 GMT

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