Create a measure that applies a calculation, but only to selected item in slicer

[hermanjb]

I'm trying to create a measure that adds "+2" to a sum (PRODUCTS[SALES]). But I only want to add the +2 to the values selected, e.g. I select product "Product 1" in the slicer, I add +2, but for all the other products the sales value remain the same. I have created a measure:

Sales plus =

VAR SalesScenario =

    SUMX (

        Products,

        Products[Sales] + 2

    )

RETURN

CALCULATE (

    SalesScenario,

        ALLSELECTED (Products[ProductNames] )

    )

But this measure applies the +2 to sales for all products. What am I doing wrong? 

[Anonymous · Accepted solution]

HI @hermanjb,

I'd like to suggest you create a variable to store the calculation result and write an if statement to check the variable that not equal to blank, then you can add '+2' on the match condition records.

Sales plus =
VAR result =
    CALCULATE (
        SUM ( Products[Sales] ),
        ALLSELECTED ( Products ),
        VALUES ( Products[ProductNames] )
    )
RETURN
    IF ( result <> BLANK () , result + 2 )

Regards,

Xiaoxin Sheng