Measure to Sum Based on Multiple Selections in one Filter

[luvagoldenk9]

Hello,

I am creating a measure to sum dollars by month: 

MonthlySum=CALCULATE(SUM('FileYTD'[Sales]),FILTER('FileYTD','FileYTD'[Month]=SELECTEDVALUE('FileYTD'[Month])))

Need to add Month as a filter and allow the user the ability to select multiple months or just one month. SELECTEDVALUE only works on one selected month. Any suggestions of how to change the measure to SUM on any number of selected months (or all months, or 3 months based, or whatever months the user selects)?

ALLSELECTED does not work either. Any thoughts or ideas would be appreciated. Thank you!

[amitchandak · Accepted solution]

@luvagoldenk9 , first of all if you are selecting month from same table you do not need to add that to filter it should work

CALCULATE(SUM('FileYTD'[Sales]))

Above should filter from table and related tables 

even if you need a filter then

MonthlySum=

var _tab = summarize(allselected('FileYTD') , 'FileYTD'[Month])

return

CALCULATE(SUM('FileYTD'[Sales]),FILTER('FileYTD','FileYTD'[Month] in _tab ))

[luvagoldenk9]

Thank you amitchandak!

The second version you suggested in your response above worked like a champ. Really do appreciate your assistance and help!!