How to detect MORE than 1 value in a Slicer

[marciomendonca]

Good Morning, community. Here is my problem:

I have this slicer from Jan to Aug whereas each month has its own goal to be achieved, luckly from Jan to Jul the goal is the same, but in Aug the value changed.

So now I want to automaticaly change the goal accordingly with the selected(s) month(s). I kinda figured it out already, but now I'm struggling with this issue: When I select more than 1 month (August included) it only shows the SUM of the other months but not August

Exaclty same value if August is selected

August's goal

So I want to be able to detect if the August value was selected or not, so then the goal will be adjusted accordingly.

Btw, both goals are in the same Table but in different columns.

[amitchandak]

@marciomendonca , You check if august is selected 

if( "August" in Values(Date[Month]), 1,0)

Check has one value to make sure one value is selected - https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[marciomendonca]

Sadly, didn't work 😞