Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

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...

Need Help

BA_Pete
5 years ago
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

BA_Pete

Super User

5 years ago

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

Anonymous

Not applicable

5 years ago

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
5 years ago
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