Measure

[razan_5r5]

Hi i want measure in power bi that filter multible values in one column for example 

Accaptance 1 = CALCULATE(COUNT('R2 RCC Referral dashboard'[رقم الإحالة]),FILTER('R2 RCC Referral dashboard','R2 RCC Referral dashboard'[حالة الإحالة (الإحالة ) (الإحالة)]))="تم وصول المريض"&& "تجهيز وسيلة النقل" && "تم القبول من مدير الحالة"/[Total] 

But i get this error 

[razan_5r5]

Hi Tom 

attached as you request https://1drv.ms/u/s!ApQAUR6a546zgYd_uAovQ4iRIQDvWg?e=9rHsZK

i want to make a measure that calculate 1st appointment Waiting Time for new patients

and % of 1st time appointments received in subspecialties within 4 weeks and Percentage of patients who wait more than 30 minutes from appointment time to physician encounter accourding to the data in power bi in the link above 

i have the formula for Percentage of patients who wait more than 30 minutes from appointment time to physician encounter it is number of patient who wait more than 30 minutes from appointment time to physician encounter / total patient seen the physician

also the formula for % of 1st time appointments received in subspecialties within 4 weeks is number of new patient received in subspecialities within 4 weeks / total new patient

i hope the requirement is clear 

Thanks 

[TomMartens]

Hey @razan_5r5 ,

unfortunately, your ask for help does not provide enough information to provide any guidance/help, at least for me.

Please, consider creating a pbix file that contains sample data that reflects your data model (tables, relationships, calculated columns, and measures), upload the file to dropbox or onedrive and share the link here in this post (I will not react to links that are shared with me in private messages).
Do not forget to describe the expected result based on the sample data you provide.

Regards,

Tom