Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Average by Category

Hi,    I am trying to calculate the average by categroy however, my numbers are not adding up.    AVERAGE =       
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Anonymous ,

     

    Try formula like below:

    M_ =
VAR count_category =
    COUNTROWS ( ALLEXCEPT ( 'Table', 'Table'[Category] ) )
VAR sum_ =
    CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table' ) )
RETURN
    DIVIDE ( sum_, count_category, BLANK () )

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

Yossarian's avatar
Yossarian
Icon for Helper I rankHelper I
4 years ago

Hey,

 

Why not just use the average function?
Put it in a table visual with category and the measure - average(Table[category])