Forum Discussion

RyanJEngLegacy's avatar
RyanJEngLegacy
New Member
3 years ago

Average Daily Census

Hello All,   I am fairly new to Power BI. I am trying to compute the Average Daily Census for a healthcare provider. We have a patient count per day which changes often but the importance would be ...
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

RyanJEngLegacy , A measure like

 

AVERAGEX(Values(Table[branch]), calculate(AVERAGEX(values(Table[Date]), calculate(Sum(Table[Census])))))

 

or

AVERAGEX(Values(Table[branch]),[Average Daily Census measure])