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
@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
@georgecrowley You might find this thread interesting. Solved: Re: No CACULATE challenge - Microsoft Power BI Community
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!