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

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