Forum Discussion
Solved
Filtering Visual with DAX
Hello, i have create a dashboard to show which contractors are on site daily - the table at the bottom is a filtered by a DAX function which returns the value 1 if the contractos fall within with...
jakemorris606 , Try a measure like
countrows(filter('Contractor Jobs', 'Contractor Jobs'[Arrival Date] <= Today() && 'Contractor Jobs'[Last Day Of Attendance] >= Today()))
Thank you Amitchandak!.