Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure for group average

I have a measure for calculationg average of number of days since last input.    I want to have another measure showing group average after filtering specific project to compare project with the gr...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    Try this:

    average = AVERAGE ( 'Table'[Days average] )
    divisional average = 
AVERAGEX (
    'Table',
    CALCULATE (
        AVERAGE ( 'Table'[Days average] ),
        ALLEXCEPT ( 'Table', 'Table'[Group] )
    )
)


    Best Regards
    Icey

     

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

Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

 

Try this:

average = AVERAGE ( 'Table'[Days average] )
divisional average = 
AVERAGEX (
    'Table',
    CALCULATE (
        AVERAGE ( 'Table'[Days average] ),
        ALLEXCEPT ( 'Table', 'Table'[Group] )
    )
)


Best Regards
Icey

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    superb !! thank you so much for this ! 

     

    would this work in a table as well ? I need a column in a table where for each row i want to see this group average (no not only when i select specific group).