How to compare individual result to the same value group average each week in a year

[KiPa]

Hi All,

can someone help or direct me to an already existing post?

I need to calculate the team average of a value in one week 

and 

compare an individual value to this average

and

do it for all weeks/year

Thank you

[Anonymous]

Hi @KiPa ,
Thanks for @audreygerred reply.
Here some steps that I want to share, you can check them if they suitable for your requirement.

Whole Team Weekly Average = 
CALCULATE(
    AVERAGE('Table'[Value]),
    ALLEXCEPT(
        'Table',
        'Table'[Week#]
    )
)

Weekly value / Weekly average = SELECTEDVALUE('Table'[Value]) / [Whole Team Weekly Average]

Final output

Best regards,
Albert He

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

[KiPa]

Hello,

is it possible it wouldn't work when the value is actually a meassure?

k.

[audreygerred · Accepted solution]

Hi! Try this: 

CALCULATE([YourMeasureforAverage],ALLEXCEPT('YourTable','YourTable'[Name]))

This should give you the average for each week for all teams since it ignores the Name field.

[KiPa]

Hello,

I am getting average with this one, but would it be possible to get Median?

So far all I see calculates Median for columns only.

Thank you

[KiPa]

Thanks a lot, this simpl eline solved it!

[audreygerred]

You are very welcome! Happy to help!