Forum Discussion
Average Patient Visit Each Weekday
Hi, I would like to calculate the average number of patients attending each weekday. I would like to show this on a bar chart. Even on a table would be fine. I have been trying to use the DAX fo...
parry2k
Super User
Super Usersanjurk_1506 maybe try this measure, change table and column name as per your model:
Measure = AVERAGEX ( VALUES ( 'Table (2)'[Weekday] ), CALCULATE ( COUNTROWS ( 'Table (2)' ) ) )