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 ,

You can use ALLSELECTED. And it would be great if you could provide some sample data.

 

Best Regards,

Icey

 

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