Add amd subtract from a measure based on slicer selectuon

[Anonymous]

Hi Experts

I have a measure which works out the organic growth YTD works fine. What I need to do is based on the selected criteria on two slicers
Slicer 1. Has Year Values
Slicer 2. Has Month Vakes

So when the user select month April and year 2018 subtract 0.01% from measure and when user select Sept 2018 add 0.01% to current measure that's it.

[v-piga-msft · Accepted solution]

Hi @Anonymous,

So when the user select month April and year 2018 subtract 0.01% from measure and when user select Sept 2018 add 0.01% to current measure that's it.

---

For your scenario, it seems that we could add the if function in the measure which works out the organic growth YTD to determine if the slicers are filtered.

You could refer to the formula below.

Add amd subtract from a measure based on slicer selectuon =
VAR selectyear =
    SELECTEDVALUE ( Sheet13[Date].[Year] )
VAR selectmonth =
    SELECTEDVALUE ( Sheet13[Date].[Month] )
RETURN
    IF (
        selectyear = 2018
            && selectmonth = "April",
        [Measure] - 0.01,
        IF (
            selectyear = 2018
                && selectmonth = "September",
            [Measure] + 0.01,
            [Measure]
        )
    )

If you still need help, please share your data sample and your desired output so that we could help further on it.

Best  Regards,

Cherry

[Anonymous]

Many Thanks Cherry, excellent feedback as always