Passing values from Multiselect slicer to DAX measure

Using IN operator in DAX we achieved this functionality on selecting multiple values from Month and Year slicer we are able to display Revenue and Budget fields.

Power Query:

Monthly Rev (Multiselect) =

VAR SelectedMonths = ALLSELECTED ( Calender1[month] )

var selectedyear=ALLSELECTED(systemusers[UserYear])

RETURN

CALCULATE(SUM(DR_StravaInvoicesbyGLCategory[Extended Price]),FILTER(DR_StravaInvoicesbyGLCategory,DR_StravaInvoicesbyGLCategory[Month] IN SelectedMonths),FILTER(DR_StravaInvoicesbyGLCategory,DR_StravaInvoicesbyGLCategory[Year] IN selectedyear))

Similarly, to a measure having no month fields in the data we are able to solve this by using STRINGCOMPARE.

Power Query :

MonthBud(multi) =

VAR SelectedMonths = ALLSELECTED ( Calender1[month] )

var selectedyear=ALLSELECTED(systemusers[UserYear])

var mon1=IF(ISFILTERED(Calender1[month]),CONCATENATEX(ALLSELECTED(Calender1[month]),Calender1[month],”,”))

var mon2=CALCULATE(IF(CONTAINSSTRINGEXACT(mon1,”January”),CALCULATE(SUMX(strava_goals,strava_goals[strava_january])),0)+IF(CONTAINSSTRINGEXACT(mon1,”February”),CALCULATE(SUMX(strava_goals,strava_goals[strava_february])),0)+IF(CONTAINSSTRINGEXACT(mon1,”March”),CALCULATE(SUMX(strava_goals,strava_goals[strava_march])),0)+IF(CONTAINSSTRINGEXACT(mon1,”April”),CALCULATE(SUMX(strava_goals,strava_goals[strava_april])),0)+IF(CONTAINSSTRINGEXACT(mon1,”May”),CALCULATE(SUMX(strava_goals,strava_goals[strava_may])),0)+IF(CONTAINSSTRINGEXACT(mon1,”June”),CALCULATE(SUMX(strava_goals,strava_goals[strava_june])),0)+IF(CONTAINSSTRINGEXACT(mon1,”July”),CALCULATE(SUMX(strava_goals,strava_goals[strava_july])),0)+IF(CONTAINSSTRINGEXACT(mon1,”August”),CALCULATE(SUMX(strava_goals,strava_goals[strava_august])),0)+IF(CONTAINSSTRINGEXACT(mon1,”September”),CALCULATE(SUMX(strava_goals,strava_goals[strava_september])),0)+IF(CONTAINSSTRINGEXACT(mon1,”October”),CALCULATE(SUMX(strava_goals,strava_goals[strava_october])),0)+IF(CONTAINSSTRINGEXACT(mon1,”November”),CALCULATE(SUMX(strava_goals,strava_goals[strava_november])),0)+IF(CONTAINSSTRINGEXACT(mon1,”December”),CALCULATE(SUMX(strava_goals,strava_goals[strava_december])),0),FILTER(strava_goals,strava_goals[strava_fiscalyear] IN selectedyear),FILTER(strava_goals,strava_goals[statecode]==0))

return mon2