Forum Discussion

PoojaG's avatar
PoojaG
Icon for Helper II rankHelper II
7 years ago
Solved

Average Message per hour

Hello experts,   I am trying to calculate Average message per hour.  There were couple of similar post but none worked as per my requirement. Seems to be straight forward but not really. It can be ...
Need Help
  • PoojaG's avatar
    PoojaG
    7 years ago

    I was able to get the desired results with the below DAX:

    DIVIDE(CALCULATE(SUM(Posts[post count])),CALCULATE(SUM(DateTime[rowcount])),0)
PoojaG's avatar
PoojaG
Icon for Helper II rankHelper II
7 years ago

I was able to get the desired results with the below DAX:

DIVIDE(CALCULATE(SUM(Posts[post count])),CALCULATE(SUM(DateTime[rowcount])),0)