Select and calculate all dates from slicer

deannapi — Fri, 23 Feb 2024 15:05:03 GMT

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

Re: Select and calculate all dates from slicer

qqqqqwwwweeerrr — Sat, 24 Feb 2024 06:45:20 GMT

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

topic Select and calculate all dates from slicer in DAX Commands and Tips

Select and calculate all dates from slicer

Re: Select and calculate all dates from slicer