Forum Discussion

Anonymous's avatar
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's avatar
    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's avatar
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's avatar
    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's avatar
      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