Forum Discussion

learning_dax's avatar
learning_dax
Icon for Helper II rankHelper II
4 years ago

Dynamic Filter Based On Selected Date Slicer

Hi all,    This is a mock screenshot of a monthly report to track # of phone calls we make. We operate on a fiscal year from June 1 to May 31. Referring to the picture below, I am stuck on how to c...
Filter based on context
SELECTEDVALUE
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

learning_dax , Assume you have selected a date

 

new measure =

var _max1 = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())

var _max = if(month(_max1 ) <9, Date(year(_max1 ),8,31) ,Date(year(_max1 )+1,8,31) )

var _min = eomonth(_max1,0)+1

return

//you can use _min and _max in formula

 

learning_dax's avatar
learning_dax
Icon for Helper II rankHelper II
4 years ago

amitchandak Not sure how I would structure the calculation still. Do I use them as filters? The first part of my calculate function would be to calculate # of phone calls so:

CALCULATE(COUNT(Phone_Call_Date))

My selected value as seen in the picture is Month & Year format: August 2022. Does this change anything of the filter context? I'm still not sure how I would build the calculation based on showing future phone calls based on the selected month/year in the slicer.