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.

lc_finance's avatar
lc_finance
Solution Sage
6 years ago

Hi Anonymous ,

 

could you include a sample version of your Power BI file?

You can share it via DropBox, One Drive, Drive or any similar tool.

 

Regards

 

LC