Forum Discussion
SUM countrows measure
I have a measure that grabs the count of appointments each day in a COUNTROWS measure, Count Appointments = COUNTROWS(FILTER('Appointment Times with date','Appointment Times with date'[Working...
Hi Anonymous ,
So, it sounds like you just want to filter your data for specific dates, right?
In that case, you just need to put your measure into a visual with dates in it, then put your dates into a slicer on the page and set the slicer to a 'Between' type, like this:
Pete
Thanks for this. It's along the lines of what I need but rather than divide the no of days by appointment .
Is it possible to have something like:
_appointmentsPerDay =
VAR __noofDays =
DATEDIFF("09/09/2021", "16/09/2021", DAY)
RETURN
SUM([Count Appointments] over these dates?
e.g. 33 appointments per day over 7 days = 231 apps.
thanks again!
BA_Pete
Super User
Super UserHi Anonymous ,
So, it sounds like you just want to filter your data for specific dates, right?
In that case, you just need to put your measure into a visual with dates in it, then put your dates into a slicer on the page and set the slicer to a 'Between' type, like this:
Pete