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 Hours]= "Yes"))
However I'd trying to comeup with a way to count this measure (e.g. 33 appointments a day) between two dates e.g. 09/09/2021 and 16/09/2021.
Thanks
File here
https://www.dropbox.com/s/yp912cepf4x3rec/Appointment%20Count%20Test.pbix?dl=0
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
3 Replies
Hi Anonymous ,
Try this measure:
_appointmentsPerDay = VAR __noofDays = DATEDIFF([Scalar Start Date], [Scalar End Date], DAY) RETURN DIVIDE([Count Appointments], __noofDays, 0)You will need a way to populate the scalar date values, whether this is through measures or slicer selections etc. is up to you, but you'll need to find a way to get those in there.
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)RETURNSUM([Count Appointments] over these dates?e.g. 33 appointments per day over 7 days = 231 apps.thanks again!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