Forum Discussion
razan_5r5
4 years agoFrequent Visitor
calculation
- 4 years ago
Hi, razan_5r5 ;
Please try it.
Percent = var _count30= CALCULATE(COUNT('Table'[patients]),FILTER(ALL('Table'),DATEDIFF([appointment time],[time seen],MINUTE)>30)) return DIVIDE(_count30,COUNTX(ALL('Table'),[patients]))The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
razan_5r5
4 years agoFrequent Visitor
i do not understand this step
1/24/60 * 30),1,0)