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)
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

PoojaG ,

 

"Measure * Measure" and "Measure / Measure" will cause complex issue. I would suggest you to convert measures [total hours] and [Count of Post] to calculate columns and then create measure using them.

 

Regards,

Jimmy Tao

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

    v-yuta-msft  I converted the measure into calculated columns and then averged them, it still doesn't give me correct results.