Measure

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