Forum Discussion
Solved
Calculate Monthly Average Cases per Resource
Good day, everyone! I have already tried researching multiple boards and have also searched online but I can't seem to get the right formula on this one. I have a dataset like this: ...
Hi faustusxanthis
If i understand you correctly please modify your dax formula to :Test Average = divide( SUMX(VALUES('Table'[Resource]), COUNT([Case id])),DISTINCTCOUNT('Table'[Closed Month]))If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983
Super User
Super UserHi faustusxanthis
If i understand you correctly please modify your dax formula to :
Test Average = divide( SUMX(VALUES('Table'[Resource]), COUNT([Case id])),DISTINCTCOUNT('Table'[Closed Month]))
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
