Select and calculate all dates from slicer

[deannapi]

I have a slicer of a date column but every day is on the 1st like

Month-Year

1/1/2023

2/1/2023

3/1/2023

4/1/2023

5/1/2023

So I want the slicer to be a date hierarchy of Year and Month only:

Then I have a measure to calculate a total of a column based off slicer selection, but it's not allowing me to select multple values.

Online Revenue =
VAR SelDates =
   SELECTEDVALUE( Table[Month-Year] )

VAR Revenue =
   CALCULATE(
      SUM( Table[Revenue] ),
      AND( Table[Month-Year] = SelDates,
           Table[Type] = "Online" ) 
   )

RETURN
Revenue

[qqqqqwwwweeerrr · Accepted solution]

Hi @deannapi 

you create to measure something like this: replace the correct column name with yours 

sum condition = CALCULATE(SUM(data[Ammount]),FILTER(data,data[type]= "Online"))

Did I answer your question if not please provide more details? if yes please Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards