Measure with Variables and Filters

Hi raymond - 

In the very specific instance you provided, this code gets you what you want, but I doubt it is very scalable since there are still hard-coded values inside.

New Score = 
var __Email = SELECTEDVALUE(Mailings[Name])
var __Phase = SELECTEDVALUE(Mailings[Phase])
var __A =     CALCULATE(
        DIVIDE( [click-rate] , [click-rate TARGET 20%] , BLANK() ) ,
        Mailings[Phase] IN {"Initial"} ,
        Mailings[Name] IN {"E-Mail_A"})

var __B =     CALCULATE(
        DIVIDE( [click-rate] , [click-rate TARGET 75%] , BLANK() ) ,
        Mailings[Phase] IN {"Initial"} ,
        Mailings[Name] IN {"E-Mail_B"}
        )

return

IF(
   ISBLANK(__Email), //SELECTEDVALUE returns BLANK if more than one value comes back
   __A+__B, 
    SWITCH(
        TRUE(), 
        __Email = "E-Mail_A", __A,
        __Email = "E-Mail_B", __B
    ))

It's also worth noting that the sample report file you provided, and the 2nd set of detail do not really match the initial question. I realize that you were trying to obscure sensitive data, but if you look at your 2nd and 3rd posts, they're quite different.

Sorry I couldn't be of more help

David