Forum Discussion

Icon for Helper I rank

Helper I

5 years ago

Solved

AVERAGES in a Matrix Table ??

How could I solve this problem I have a Matrix Table showing the Day of the Week and Time by Hour I have Count of Values , but if I broaden up the time frame mroe than a week , then my Values...

Anonymous
5 years ago
Hi bcampbell ,

Try
Count of number average per SOH = AVERAGEX ( ALLEXCEPT ( emmain, emmain[SOH] ), COUNTA ( emmain[number] ) )

Best Regards,
Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous

Not applicable

5 years ago

Try

Count of number average per SOH =
AVERAGEX ( ALLEXCEPT ( emmain, emmain[SOH] ), COUNTA ( emmain[number] ) )

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.