Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
KiPa
Frequent Visitor

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

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

 

KiPa_0-1721842670567.png

Thank you

1 ACCEPTED SOLUTION
audreygerred
Super User
Super User

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

6 REPLIES 6
v-heq-msft
Community Support
Community Support

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

vheqmsft_0-1721871488914.png

 

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

Hello,

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

k.

audreygerred
Super User
Super User

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





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

 

Thanks a lot, this simpl eline solved it!

You are very welcome! Happy to help!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.