How to Get Your Question Answered Quickly

Opportunity RSV = [New RSV]-[RSV]
RSV_Threshold =

var opportunityrsv=[Opportunity RSV]

return if(opportunityrsv < 0 ,-1,IF([Opportunity RSV]>0,1,0))

Opportunity Rsv Threshold =

VAR positive_opportunity_rsv = SUMX (
'Target',
IF ('Target'[RSV_Threshold]=1 , [Opportunity RSV], 0 )
)
VAR negative_opportunity_rsv = SUMX (
'Target',
IF ( 'Target'[RSV_Threshold] = -1, [Opportunity RSV], 0 )
)
VAR net_rsv = positive_opportunity_rsv - negative_opportunity_rsv

var Opportunityrsv=
SWITCH(
MAX('Opportunity RSV'[Opportunity RSV Comparison]) ,
"Negative opportunity RSV",negative_opportunity_rsv ,
"Positive opportunity RSV", positive_opportunity_rsv ,
"NET Opportunity RSV", net_rsv)

return IF(ISBLANK(SUM('Time Progression'[Progression Offset])), BLANK(), Opportunityrsv)

contribution =

var Total_RSV = CALCULATE([Opportunity RSV], REMOVEFILTERS('Target')  )

var Positive_RSV = SUMX('Target', IF('Target'[RSV_Threshold] = 1, [Opportunity RSV], 0))

var Negative_RSV = SUMX('Target', IF('Target'[RSV_Threshold] = -1, [Opportunity RSV], 0))

var Net_RSV=Positive_RSV-Negative_RSV

VAR Positive_Contribution = DIVIDE(Positive_RSV, Total_RSV, 0)

VAR Negative_Contribution = DIVIDE(Negative_RSV, Total_RSV, 0)

VAR Net_Contribution = DIVIDE(Net_RSV, Total_RSV, 0)

RETURN IF(ISINSCOPE('Opportunity RSV'[Opportunity RSV Comparison]),SWITCH(

    MAX('Opportunity RSV'[Opportunity RSV Comparison]),

    "Positive opportunity RSV",Positive_Contribution,

    "Negative opportunity RSV", Negative_Contribution,

    "NET Opportunity RSV",Net_Contribution,

   BLANK()))

contribution =

var Total_RSV = CALCULATE([Opportunity RSV], REMOVEFILTERS('Target')  )

var Positive_RSV = SUMX('Target', IF('Target'[RSV_Threshold] = 1, [Opportunity RSV], 0))

var Negative_RSV = SUMX('Target', IF('Target'[RSV_Threshold] = -1, [Opportunity RSV], 0))

var Net_RSV=Positive_RSV-Negative_RSV

VAR Positive_Contribution = DIVIDE(Positive_RSV, Total_RSV, 0)

VAR Negative_Contribution = DIVIDE(Negative_RSV, Total_RSV, 0)

VAR Net_Contribution = DIVIDE(Net_RSV, Total_RSV, 0)

RETURN IF(ISINSCOPE('Opportunity RSV'[Opportunity RSV Comparison]),SWITCH(

    MAX('Opportunity RSV'[Opportunity RSV Comparison]),

    "Positive opportunity RSV",Positive_Contribution,

    "Negative opportunity RSV", Negative_Contribution,

    "NET Opportunity RSV",Net_Contribution,

   BLANK()))