Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
VivianC
Helper I
Helper I

Median/STDEV For Each Unique Name From Multiple Values

‎10-24-2018 01:29 PM

Hello,

I have a table like below. I want to calculate the Median from multiple values  (and Standard Deviation, but here I just show Median as example) based on each unique Key_CountrySkill column:

 

Median.png

 

Stuck here for hours...Can someone help please? Thanks!

Message 1 of 3
515 Views
0
1 ACCEPTED SOLUTION
v-jiascu-msft
Employee
Employee

‎10-25-2018 02:39 AM

Hi @VivianC,

 

You can do it like below. Please also check out the demo in the attachment.

 

Median =
CALCULATE (
    MEDIAN ( Table1[Annualized USD] ),
    ALLEXCEPT ( Table1, Table1[Key_CountrySkill] )
)

Stdev =
CALCULATE (
    STDEV.P ( Table1[Annualized USD] ),
    ALLEXCEPT ( Table1, Table1[Key_CountrySkill] )
)

 

Best Regards,
Dale

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

View solution in original post

Median STDEV For Each Unique Name From Multiple Values.pbix
Message 2 of 3
496 Views
2 REPLIES 2
v-jiascu-msft
Employee
Employee

‎10-25-2018 02:39 AM

Hi @VivianC,

 

You can do it like below. Please also check out the demo in the attachment.

 

Median =
CALCULATE (
    MEDIAN ( Table1[Annualized USD] ),
    ALLEXCEPT ( Table1, Table1[Key_CountrySkill] )
)

Stdev =
CALCULATE (
    STDEV.P ( Table1[Annualized USD] ),
    ALLEXCEPT ( Table1, Table1[Key_CountrySkill] )
)

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Median STDEV For Each Unique Name From Multiple Values.pbix
Message 2 of 3
497 Views
VivianC
Helper I
Helper I
In response to v-jiascu-msft

‎10-25-2018 06:08 AM

OMG you are awesome!! Thanks!!!

Message 3 of 3
493 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

View All