Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Measure for calculating appointments

I have the following measure for which counts the number of appointments for a given day: CALCULATE(COUNT(Appointment[Date appointment]), FILTER(Appointment, Appointment[Status] = "Planned" || Appo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Anonymous I get the same result with this measure. The value for January 4th, for example, should be '942'. The booking date should not be larger than the 'row date' that is displayed in the table (which comes from Calendar[Date]). Any ideas?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

I would first consider the relationship, can 'Appointment'[Booking date] be filtered by 'Calendar'[Date]?

 

Would you mind providing some sample files that do not contain sensitive data? It would be helpful to find out why, thanks in advance!

How to provide sample data in the Power BI Forum

 

Best Regards,
Gao
Community Support Team

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Anonymous Please find a sample file here: PBI sample file

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    The formula output is correct. Does your expected output need to consider de-duplicating the count of the results? This may be the reason for the larger result. Please check this file. The latter output is the result of considering the de-duplication.

    If I misunderstood your needs, you could pick a date and demonstrate the calculation process and output based on this file, thanks in advance!

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Dear Anonymous Thank you for your help! In the same PBI file, I have added a page (page 2) with manual filters which provides an example of the result I am looking for. I have also added some comments to try and clarify things further. Does this maybe clarify things? PBI file