DAX to remove the null values from the maximum and minimum selected date slicer?

[deb_power123]

Hi All,

I have the below Student table with columns as below :-

StudentID
StudentName
LastAttendanceDate
StudentType

I have some null values for the Last attendance Date .I have a table visualization for the student table and have a date slicer with Last Attendance Date filter.

I want to remove all the null values for the selected minimum and maximum date range in my date slicer .

My input data :

StudentID	StudentName	LastAttendanceDate	StudentType
100	Harry	10-05-2011 10:45	Fulltime
100	Harry		Fulltime
101	Mary	02-05-2011 12:45	Fulltime
101	Mary	02-05-2011 15:45	Fulltime
101	Mary		Fulltime
101	Mary	02-05-2011 19:45	Fulltime
102	James	02-05-2011 12:45	Part Time
102	James	02-05-2011 18:45	Part Time
103	John	12-05-2011 12:45	Part Time
103	John	12-05-2011 14:45	Part Time
103	John		Part Time
103	John	12-05-2011 16:45	Part Time
103	John	14-05-2011 16:45	Part Time

My visualization slicer:

Expected Output:

The ones which are ticked these rows should be removed based on my selection range of date slicer:

Please suggest a dax measure to handle this.

I tried a measure below it didnt work:-

filter_measure =

var x1= calculate Max(student[LastAttendanceDate],ALLSELECTED(student[LastAttendanceDate])

var x2= calculate Min(student[LastAttendanceDate],ALLSELECTED(student[LastAttendanceDate])

return

IF(NOT(ISBLANK(Max(student[LastAttendanceDate])= null,1,0)

IF(NOT(ISBLANK(Min(student[LastAttendanceDate])= null,T,F)

I need to exclude all those null values for Last Attendance date when i select any given range in my date slicer.

student may come on the next day to school but for the datetime which is null I should get rid of that row

Kind regards

sameer

[amitchandak · Accepted solution]

@deb_power123 , Add a visual level filter LastAttendanceDate is not blank

or in your measure like

calculate(Min(student[LastAttendanceDate]),filter(student,not(isblank(student[LastAttendanceDate]))))

[deb_power123]

Thankyou Amit :)..you are awesome