Forum Discussion

deannapi's avatar
deannapi
Frequent Visitor
2 years ago
Solved

Select and calculate all dates from slicer

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

 

dates
Slicer
  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    2 years ago

    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

1 Reply

  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    Icon for Solution Sage rankSolution Sage
    2 years ago

    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