Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
Solved! Go to Solution.
Hi! Try this:
Proud to be a Super User! | |
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
Hello,
is it possible it wouldn't work when the value is actually a meassure?
k.
Hi! Try this:
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!
Proud to be a Super User! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
211 | |
86 | |
64 | |
59 | |
56 |