Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
40 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |