Forum Discussion
IF statement w/ expression as value_if_true
I'm trying to wrap a DIVIDE in an IF statement to handle a condition where the DIVIDE returns BLANK(). I want to use an expression for the value_if_true. How can I do this? Here is my code which ...
ah, my bad, a missing return
Cost per Opportunities Closed Won = VAR r = DIVIDE ( SUM ( 'Nexus-Campaigns'[Actual Campaign Cost] ), [Opportunities Closed Won] ) RETURN IF ( ISBLANK ( r ), SUM ( 'Nexus-Campaigns'[Actual Campaign Cost] ), r )
Salesforce? :-)
Cost per Opportunities Closed Won =
var r=DIVIDE (
SUM ( 'Nexus-Campaigns'[Actual Campaign Cost] ),
[Opportunities Closed Won]
)
IF (ISBLANK(r),
SUM ( 'Nexus-Campaigns'[Actual Campaign Cost] ),
r
)Yup. Salesforce.
I'm getting a syntax error when I try to use that forumla as a measure.
"The syntax for 'IF' is incorrect. (DAX(var r=DIVIDE ( SUM ( 'Nexus-Campaigns'[Actual Campaign Cost] ), [Opportunities Closed Won] )IF (ISBLANK(r), SUM ( 'Nexus-Campaigns'[Actual Campaign Cost] ), r)))."
ah, my bad, a missing return
Cost per Opportunities Closed Won = VAR r = DIVIDE ( SUM ( 'Nexus-Campaigns'[Actual Campaign Cost] ), [Opportunities Closed Won] ) RETURN IF ( ISBLANK ( r ), SUM ( 'Nexus-Campaigns'[Actual Campaign Cost] ), r )Thanks.
I'm going to learn how to use variables.